Nested IF with Children

Greetings,

I'm attempting to configure an Epic (parent) field to automatically change based on the statuses of the child fields. For example, the criteria I'm attempting to meet is:

If all child status fields are in "To Do" then parent field status is "To Do" else "In Progress"
If all child status fields are in "Done" Then parent field status is "Done" else "In Progress"

I've written two separate formulas that work, but I have so far failed to combine them. So far what I have for item number 1 is:

=IF(AND(COUNTIF(CHILDREN(), "To Do") > 0, COUNTIF(CHILDREN(), "To Do") = COUNT(CHILDREN())), "To Do", "In Progress")

And for item number 2 I have:

=IF(AND(COUNTIF(CHILDREN(), "Done") > 0, COUNTIF(CHILDREN(), "Done") = COUNT(CHILDREN())), "Done", "In Progress")

I've attempted to combine them into the following with no success:

=IF(AND(COUNTIF(CHILDREN(), "To Do") > 0, COUNTIF(CHILDREN(), "To Do") = COUNT(CHILDREN())), "To Do", "In Progress", IF(AND(COUNTIF(CHILDREN(), "Done") > 0, COUNTIF(CHILDREN(), "Done") = COUNT(CHILDREN())), "Done", "In Progress")

Any help is appreciated, thanks!

Find more posts tagged with

Formulas

functionality

IT & Operations

Project Management

Accepted answers

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN(), "To Do") = COUNT(CHILDREN()), "To Do", IF(COUNTIFS(CHILDREN(), "Done") = COUNT(CHILDREN()), "Done", "In Progress"))

All comments

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN(), "To Do") = COUNT(CHILDREN()), "To Do", IF(COUNTIFS(CHILDREN(), "Done") = COUNT(CHILDREN()), "Done", "In Progress"))

Evan Summerville

That worked, thanks Paul!

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