Check Parent box if Child box is checked
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?
Best Answer

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.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

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.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!