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

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

Answers

  • Christina09
    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)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!