Conditional Hide


I would like to use conditional hiding of sheets and rows in the same report, is this possible?

Right now I am struggling with the conditional hide of sheets. In the cells A2 and B1 I entered Hide+?. In the cell B2 I have a IF-formula with the condition to hide the sheet (IF(condition,hidesheet,show). Additionally I have a condition in row B to hide the rows (IF(condition,hide,show). Running the report hides all the rows I don't want to see, but the unwanted sheets don't disappear. The IF formula in B2 works perfectly, the result is HideSheet in the unwanted sheets. 

Thank you very much.


Please sign in to leave a comment.