Making Parent Rows Display the Lowest status of their Children Rows

Hey everyone, I'm looking to have my parent rows simply display the lowest status of their children rows.

My statuses are Complete, In Progress, Not Started.

Pretty basic but I keep having hang ups for some reason. I don't know if it's because some of my children rows have children of their own to break up the task into steps?

Any help would be great. Not sure if a screenshot will help as it is a very basic problem.

Find more posts tagged with

Accepted answers

All comments

Walter Mootz

Figured out my problem, just had an extra " in my formula.

=IF(COUNTIF(CHILDREN(), "Not Started") >= 0, "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", "Complete"))

Genevieve P.

Hi @Walter Mootz

I'm glad to hear you figured this out! Thanks for posting your solution 🙂

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.