Check Parent box if Child box is checked

NitaP

I have a column of checkboxes and would like to check the Parent box if any of the children boxes are checked. What's the formula to do that?

Jeff Reisman

Try this in your checkbox column on the parent row:

=IF(COUNTIF(CHILDREN(Checkbox@row), 1) >0, 1, 0)

(where "Checkbox" is the column name for the checkbox column)

English: If the count of child rows where the checkbox is checked is greater than 0, set this checkbox to 1 (checked,) otherwise set it to 0 (unchecked.)

Jeff Reisman

Try this in your checkbox column on the parent row:

=IF(COUNTIF(CHILDREN(Checkbox@row), 1) >0, 1, 0)

(where "Checkbox" is the column name for the checkbox column)

English: If the count of child rows where the checkbox is checked is greater than 0, set this checkbox to 1 (checked,) otherwise set it to 0 (unchecked.)

NitaP

Thank you!