# Nested IF statements counting Children color status

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

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

• Thank you Kelly!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!