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


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    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

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    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!