0

Conditional Hide

Judith Stettler

April 26, 2019 06:04

None

Follow

Hi,

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.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis April 26, 2019 21:19

  Hello Judith -

  Yes, you can use condition hiding for both sheets and rows on the same sheet.

  Here is a quick example I put together:

  

  I have three worksheets that are identical except for the contents of cell C3 (on the First and Third sheets, the value is 1 - triggering the hidesheet... on the Second, the value is 2)

  When I run the report:

  

   

  only the Second sheet shows (because of the Hidesheet on the other two) and you see that any record with a zero balance (rows 6-12, 14-16, 21, and 27) is hidden.

  If this is how your report is set up and you are still experiencing an issue, I would submit a request to the Jet Support Team so that they can help you troubleshoot your specific report.

• 0
  
  Judith Stettler April 29, 2019 05:47

  Hi Harry,

  Thank you for the answer. I guess it is not working in my workbook, because I use a nl(rows) and an nl(sheets) function. Additionally the IF function for the Hidesheet is based on the count of shown rows (D5). This nested condition for hiding the sheet is probably not possible.