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.