Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide sheet for null field

Hi friends,

I have two sheet,Sales and Finance, in sales I have data in fields, but in finance i have no data in fields. I want to hide the sheet for finance because its fields dont have data but when the field will get data that sheet will be shown

PFA to test

5 Replies
maleksafa
Specialist
Specialist

try this one, i have created a variable vCount that get the count of AA + BB + CC + DD, and in the sheet expression i set it to conditional where vCount > 0

Not applicable
Author

I just attached a sample file but in real i have more than 50 fields then how is this possible to do

Not applicable
Author

Thanks anyway I got the solution

maleksafa
Specialist
Specialist

can you share it ?

Not applicable
Author

Please find the attachment