Parent completed when any child is complete & parent completed when ALL children complete

Stwillis

Hello,

I am looking for two formulas.

• I need a formula to check a parent checkbox when any child is also checked. I tried to use a nested descendants formula but I keep getting errors.

When any TestAccount child is checked, I want the TestAccount Parent to be checked so I can then set up automation to copy the parent and child over to a new sheet.

• I need a formula that will change the parent task to complete when all of the child tasks are marked complete. For example, when all child steps are done for technical introduction, I want the parent task of technical introduction to be complete. When all steps for technical introduction & requirements gathering are complete, I want the parent task for execution to be complete.

Appreciate the help!

Stephanie

Christina09

HI @Stwillis,

For the first one, here is the formula for it: =IF(COUNTIF(CHILDREN(), @cell) > 0, 1)

If it's more than 0 checked, it'll check the parent checkbox.

This is the second formula for if you want the parent row checkbox to check when all children row checkboxes are checked.

=IF(COUNTIFS(CHILDREN(), 1) = COUNT(CHILDREN([Status]@row)), 1)