Parent = "complete" when all children are

I want a parent cell to register as "complete" when all children have been marked as "complete". I've tried a few things but none are working.


Any help would be great!

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @gregorc3

    Paul's formula is the one to use, but since your Status column contains text, you'll want to swap out 1 for "Complete", like so:

    =IF(COUNTIFS(CHILDREN(), @cell <> "Complete") = 0, "Complete", "Incomplete")

    Does that make sense?

    Cheers,

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!