How to automatically check a parent row when children are checked?

Options

Hi,

I have 3 level parent-children rows. I also have a column with a checkbox. Is there a formula or automation that would check the parent row if all children are checked?


Best Answers

  • Michael Culley
    Michael Culley ✭✭✭✭✭
    Answer ✓
    Options

    I would do something like this on your parent checkboxes:

    =IFERROR(IF(COUNTIF(CHILDREN([checkbox column]@row), 1) / COUNT(CHILDREN([checkbox column]@row)) = 1, 1, 0), 0)

  • Michael Culley
    Michael Culley ✭✭✭✭✭
    Answer ✓
    Options

    You forgot some parentheses.

    There should be one after [Column3]@row)

    Try copying this one below:

    =IFERROR(IF(COUNTIF(CHILDREN([Column3]@row), 1) / COUNT(CHILDREN([Column3]@row)) = 1, 1, 0), 0)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!