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

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

Try something like this...
=IF(COUNTIFS(CHILDREN(), @cell <> 1) = 0, 1)

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 :)

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 :)
Help Article Resources
Categories
Check out the Formula Handbook template!