Nested IF statements counting Children color status

Paul Watts

Hey community,

I've found simpler versions of this in the messages, but can't get this one correct.

The logic I'd like to express is:

If any children under Flag show a Red, then the parent cell (Flag1) is Red
If children Yellows are >= Green children, then the parent cell is Yellow
Green otherwise.

The code I have is:

=IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red",

IF(AND(COUNTIFS(CHILDREN(), "Yellow" >= COUNTIFS(CHILDREN(), "Green"), "YELLOW",

"Green"))))

Getting "Incorrect Argument". Help? Thanks, Paul

Find more posts tagged with

Conditional Formatting

Accepted answers

Kelly Moore

Hey @Paul Watts

The formula just needs a small adjustment. The Countifs for the Yellow is not closed off before making the comparison to the Countifs for Green.

=IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= COUNTIFS(CHILDREN(), "Green"), "Yellow", "Green"))

cheers

Kelly

All comments

Kelly Moore

Hey @Paul Watts

The formula just needs a small adjustment. The Countifs for the Yellow is not closed off before making the comparison to the Countifs for Green.

=IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= COUNTIFS(CHILDREN(), "Green"), "Yellow", "Green"))

cheers

Kelly

Paul Watts

Thank you Kelly!

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.