[Help] Change the value of the value of a parent row depending on the statuses of their children

AleDL

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?

AleDL

I think i did it. Is it 

=IF(COUNTIF(CHILDREN(), "Awaiting") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "Done") = COUNT(CHILDREN()), "Completed", "In Progress"))

?

AleDL

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?

AleDL

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

Paul Newcome

Looks like you have it pretty figured out. Well done.