Status Column updating for Parent

I have a column "Current Status" that is filled in for each child row. I would like to automate the parent row showing in the following order

If "In Progress" appears for any child, then show "In Progress" for the parent

If "On Deck" appears for any child, then show "On Deck" for the parent

If "Manage" appears (but no on deck or in progress) then show "Manage"

Find more posts tagged with

Accepted answers

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(), "On Deck") > 0, "On Deck", "Manage"))

All comments

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(), "On Deck") > 0, "On Deck", "Manage"))

Emily McNeeley

Perfect, thanks Paul - I was so close with what I had tried!

Paul Newcome

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