I have to deliver a project, please help me.
According to the picture I posted
Cell A1 has a checkbox,
if it is True, the checkmarks of the cells {B2, B7, B10, B14, and similar to it…} must also be True.
And all the rows below A1 are hidden
But
If A1 checkbox is False, the checkbox of the cells {B2, B7, B10, B14, and similar to it…} must be False.
and all rows (2,7,10, 14, …) are displayed.
The same thing happened to checkbox in cell D1.
checkbox D1 is True then
All rows (3, 4, 5, 6) (8, 9) ( 11, 12, 13) (15, 16, 17, 18) (and so on)= Hidden
All checkbox in column E is true
checkbox D1 is False then
All rows (3, 4, 5, 6) (8, 9) ( 11, 12, 13) (15, 16, 17, 18) (and so on)= displayed
All checkbox in column E is False
Those who can help, please do not hesitate
My 2 previous questions, which are for this project, remain unanswered!
sheets with my data
WEBoard is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.