[Help] Change the value of the value of a parent row depending on the statuses of their children
Hi Everyone,
I've seen many articles about this, but i can't seem to figure out how to do this.
I have a row with the name of the project (PARENT) and, indented in it, rows that are tasks part of that project (CHILDREN).
Also, there's a column called Status, with 3 variables as a dropdown menu:
Awaiting
In Progress
Completed
I need a formula that says:
If everything's in status Awaiting, then "Not started",
If everything's in status Done, then "Completed",
If not, "In progress"
For some reason i can't seem to get this done.
Can someone help me?
Comments

I think i did it. Is it
=IF(COUNTIF(CHILDREN(), "Awaiting") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "Done") = COUNT(CHILDREN()), "Completed", "In Progress"))
?

I have a second problem.
Another Status row:
4 Statuses:
Awaiting
In Progress
To Fix
Done
If everything's "awaiting", "Not Started".
If Everything's either "To Fix" or "Done", Completed
Everything else, In progress.
Can you help me with this?

=IF(COUNTIF(CHILDREN(), "Awaiting") = COUNT(CHILDREN()), "Not Started", IF(SUM(COUNTIF(CHILDREN(), "To Fix"), COUNTIF(CHILDREN(), "Okay")) = COUNT(CHILDREN()), "Completed", "In Progress"))

Looks like you have it pretty figured out. Well done.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!