Parent = "complete" when all children are

11/26/21
Accepted

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. admin
    Accepted 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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try something like this...

    =IF(COUNTIFS(CHILDREN(), @cell <> 1) = 0, 1)

    thinkspi.com

  • Thanks for trying to help!

    So that is just returning a "1". I want the project management - Status cell to mark as "complete" when all children cells are "complete" but mark "incomplete" if one or more children cells are anything but "complete".

    Hope this makes sense :)

  • Genevieve P.Genevieve P. admin
    Accepted 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

  • Fab that works! Appreciate the clarification :)

Sign In or Register to comment.