Hello,
I need to check a box in a parent cell only when all children cells in that column have been checked. I will manually paste this formula into multiple parent cells in my sheet.
The formula I tried did not work...Any guidance or tips on where I went wrong?
My thought was if I gave the range of children cells, and said "when children are true (checked) return true (checked), else False (unchecked).
The desired outcome is to drive an automation based on when a parent cell is checked. I could also look into using the red, yellow, or green lights instead of checkboxes.
In that scenario I would want children to start out as Red, and turn Parent cell Green when all children are Green.
Thanks in advance for the help!
