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