RYGB Parent and Child Roll Up

What am I doing wrong?

=IF(COUNT(CHILDREN()) > 0, IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Green") > 1, "Green", "Blue")))), IF([Status 2]@row = "Complete", "Blue", IF([Status 2]@row = "Delayed", "Red", IF(AND([Status 2]@row = "Current", [End Date]@row=TODAY(2)), "Yellow", IF([Status 2]@row = "Upcoming"), "Green", "")))

I want CHILDREN:

Delayed = Red

Current + End Date is within 3 days = Yellow

Upcoming = Green

Complete = Blue

I want PARENT

If there are Red, Red

If there are no Red but are Yellow, Yellow

If there are no Red and No Yellow, but there are Green, Green

If everything is Blue, Blue

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @MWHMax

Try this:

=IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Green") > 1, "Green", IF(COUNT(CHILDREN()) = COUNTIFS(CHILDREN(), "Blue"), "Blue", IF([Status 2]@row = "Complete", "Blue", IF([Status 2]@row = "Delayed", "Red", IF(AND([Status 2]@row = "Current", [End Date]@row = TODAY(2)), "Yellow", IF([Status 2]@row = "Upcoming", "Green"))))))))

Will it work for you?

Kelly

MWHMax

Thank you for your quick response, this formula made everything "Blue".

ChrisUPC

I used this formula on a sheet to determine if Status if CHILDREN were "Red", "Yellow" etc.

=IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNTIF(CHILDREN(), "Gray") = COUNT(CHILDREN()), "Gray", "Yellow"))))

I think yours would simply be:

=IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", "Blue")))

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.