Checkbox Automation for Parent Row

Ali Ardakani

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

kioshi43

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)

kioshi43

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)