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:

1. If any children under Flag show a Red, then the parent cell (Flag1) is Red
2. If children Yellows are >= Green children, then the parent cell is Yellow
3. 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

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

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!