Checkbox Automation for Parent Row

Options

I am looking for a solution to have a checkbox checked once all the checkboxes in the children rows are checked. The checkboxes are in the same column. I tried putting this formula in row 252 but it's not working. =IF(Status253:Status261 = "1", 1, 0)

Any suggestions?

Thanks in advance


Best Answer

  • kioshi43
    kioshi43 ✭✭✭
    Answer ✓
    Options

    If you're looking to make the whole column a formula column, you might need a helper column to act as a trigger but if you're only interested in putting the formula in the parent row, you could try this:

    =IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) = 1, 1, 0)

Answers

  • kioshi43
    kioshi43 ✭✭✭
    Answer ✓
    Options

    If you're looking to make the whole column a formula column, you might need a helper column to act as a trigger but if you're only interested in putting the formula in the parent row, you could try this:

    =IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) = 1, 1, 0)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!