Check Parent box if Child box is checked

Options

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

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    edited 01/24/22 Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!