Parent = "complete" when all children are

gregorc3

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!

Genevieve P.

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

Paul Newcome

Try something like this...

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

gregorc3

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.

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

gregorc3

Fab that works! Appreciate the clarification :)