Auto-check Checkbox

Michael Albano

Is there a formula to auto-check a PARENT checkbox if all the CHILD checkboxes are checked? Reverse of that, is there a way to check all CHILD checkboxes by simply checking the PARENT checkbox? Seems straight forward but I can't figure it out.

Paul Newcome

Check the parent:

=IF(AND(COUNTIFS(CHILDREN(), OR(@cell = 1, @cell <> 1)) > 0, COUNTIFS(CHILDREN(), @cell <> 1) = 0), 1)

Check the children:

=PARENT()

Paul Newcome

Check the parent:

=IF(AND(COUNTIFS(CHILDREN(), OR(@cell = 1, @cell <> 1)) > 0, COUNTIFS(CHILDREN(), @cell <> 1) = 0), 1)

Check the children:

=PARENT()

Michael Albano

Thanks, that did it.

Paul Newcome

Happy to help. 👍️