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!