Nested IF Statements

Stephanie Jimenez

Hello! SS newbie here. I'm having a hard time with my nested if statements. This is what I am trying to accomplish:

If number of items in Past Due Count column is =0, Traffic light is Green, 1=Yellow, 2+=Red, and if Status column (Blue Header row) ="Complete", traffic light is blue.

I have this so far:

=IF([Past Due Count]1 = 1, "Yellow", IF(AND([Past Due Count]1 >=2, "Red")), IF(AND[Past Due Count]1 = 0, "Green")), IF(AND([Status]1 = "Complete", "Blue"))

Kelly Moore

Hey @Stephanie Jimenez

The IF(AND)function is used when you have two simultaneous conditions that must be met before a statement is true. Your conditions are single statements- for instance it doesn't take Status to be Complete AND [Past Due Count] to be less than .

=IF(Status@row = "Complete", "Blue", IF([Past Due Count]@row = 1, "Yellow", IF([Past Due Count]@row = 0, "Green", "Red")))

cheers,

Kelly