Check a box in Parent cell based on children cells

M_L

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!

Darren Mullen

Hi,

Best way is to look at the count of the indented cells that are checked and compare the the overall count. Check out my example here to see formulas:

https://www.youtube.com/watch?v=Dzo0UYjxMmI&t=1s

Darren Mullen

Hi,

Best way is to look at the count of the indented cells that are checked and compare the the overall count. Check out my example here to see formulas:

https://www.youtube.com/watch?v=Dzo0UYjxMmI&t=1s

M_L

Hi Darren,

That works! Thank you