Nested IF Statements


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
    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")))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!