Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a question when hiding and showing sheets depending on data availability.
I managed to hide sheets with null data by setting condition under sheet property. (General-> Show Sheet -> Conditional -> Set Conditions)
It seems once the sheets are hidden, they are going to be hidden for good even thou the data is reloaded and I expect to see the sheets that I set to hide previously.
Is there any ways that I can reactivate the sheets?
Any advice would be appreciated.
Thanks much,
Hitomi
Hi,
You can hide the sheets by using the conditions like this
=Sum(Sales) > 0
OR
=Count(Orders) > 0
If this type of conditions fails it hides the sheets and if this condition pass then it will show the sheets.
Regards,
Jagan.
Hi,
You can hide the sheets by using the conditions like this
=Sum(Sales) > 0
OR
=Count(Orders) > 0
If this type of conditions fails it hides the sheets and if this condition pass then it will show the sheets.
Regards,
Jagan.
Thank you so much Jagan! It worked!!!!!
Hi,
If you got the answer please close this thread by giving Correct Answer to the post which helps you in the getting the answer.
Regards,
Jagan.