Formula for checking Parent Checkbox when ALL Child Check boxes are checked?

Rick_Bailey

I'm trying to find a formula that can be placed in a parent check box cell, so that when ALL child checkboxes are filled in, the parent check box then becomes checked.  I have multiple columns this is needed for, so ideally looking for a solution without having to create a number of other columns to draw calculations from.

 

Thanks in advance!

J. Craig Williams

In the Checkbox column:

=COUNTIFS(CHILDREN(), 1) = COUNT(CHILDREN())

Noted that this will also check the box if there are no children.

If that is an issue, it can be addressed.

Craig

Rick_Bailey

Worked Great- Thank you very much!!

J. Craig Williams

You are welcome.

Craig

ChelseaH

How could I modify this formula to look at all rows indented under the parent row, not just the first level? 

I tried changing CHILDREN to DESCENDANT, but it doesn't work the same way. 

Please help.