Checkbox Parent Cell if any Children cells are Checked

Hello,

I am looking to use a formula that will check the box of the parent box if any of the children boxes in the same column are checked.

Can anyone help with that?

Thanks

Find more posts tagged with

Formulas

Cell linking

This:

=COUNTIF(CHILDREN(), 1) > 0

or if you prefer to use IF() statements, then this

=IF(COUNTIF(CHILDREN(), 1) > 0, 1, 0)

Craig

Thank you! That works perfectly.