Populating parent row status based on different combinations of status from child rows

CHegyi

I am using the formula below to populate my parent status but I also want the parent status to say "In Progress" if the child rows are any combination of "Complete" AND "Not Started". Right now when the child rows are a combination of "Complete" and "Not Started" the status will read "Not Started". How do I get that combination to show as "In Progess" in the parent row?

=IF(COUNTIFS(CHILDREN(),@cell = "Complete") = COUNT(CHILDREN()), "Complete",IF(COUNTIFS(CHILDREN(), @cell = "In Progress") >= 1, "InProgress", IF(COUNTIF(CHILDREN(), "Complete") =COUNTIF(CHILDREN(), <>"Not Needed"), "Complete",IF(COUNTIF(CHILDREN(), "Complete") = COUNTIF(CHILDREN(),<>"Deleted"), "Complete", IF(COUNTIF(CHILDREN(),"Not Started") = COUNTIF(CHILDREN(), <>"NotStarted"), "In Progress", "Not Started")))))

The options for status in child rows are: Not Started, In Progress, Not Needed, Deleted, Completed

che.rabajante

Hello @CHegyi

Please try this:

=IF(COUNTIFS(CHILDREN(), @cell = "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIFS(CHILDREN(), @cell = "In Progress") >= 1, "In Progress", IF(AND(COUNTIFS(CHILDREN(), @cell = "Complete") > 0, COUNTIFS(CHILDREN(), @cell = "Not Started") > 0), "In Progress", IF(COUNTIFS(CHILDREN(), @cell = "Not Started") = COUNT(CHILDREN()), "Not Started", "Not Started"))))

Hope it helps🙂

Che

che.rabajante

Hello @CHegyi

Please try this:

=IF(COUNTIFS(CHILDREN(), @cell = "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIFS(CHILDREN(), @cell = "In Progress") >= 1, "In Progress", IF(AND(COUNTIFS(CHILDREN(), @cell = "Complete") > 0, COUNTIFS(CHILDREN(), @cell = "Not Started") > 0), "In Progress", IF(COUNTIFS(CHILDREN(), @cell = "Not Started") = COUNT(CHILDREN()), "Not Started", "Not Started"))))

Hope it helps🙂

Che

CHegyi

Thank you @che.rabajante! That did it!!! I really appreciate the help!🤩