Hello, I have a spreadsheet where there is a question, and if the cell under yes is check, I want the columns underneath with more specific thing to show. For example, the first row would say "Is there fuel storage?" with yes and no columns to the right of it. If clicked yes, I want the below columns to appear, but if no is selected I want them to stay grouped and hidden.
This would be a form filled out by another person, so I want the main questions to show, like in the sample document attached, but the further information to only show if they click yes.
I want some rows hidden unless a certain cell is filled.
Solved by F. S. in 30 mins