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

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

Find more posts tagged with

Project Management

Accepted answers

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

All comments

che.rabajante

Hello @CHegyi

Please try this:

Hope it helps🙂

Che

CHegyi

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.