Formula - traffic light

Susan van Niekerk

Hi Brain trust

Trying to set a traffic light Column but keep getting errors

What am I doing wrong

=IF(OR([Status]@row = "1Sourcing", [Status]@row = "On hold"), “red”, IF(OR([Status]@row = "2HM Review", [Status]@row = "3Interview"), “Blue”, IF(OR([Status]@row = "4Due Diligence", [Status]@row = "5DD Complete", [Status]@row = "6Offer Pending", [Status]@row = "7offer Issued"), “yellow”, IF(OR([Status]@row = "8Onboarding", [Status]@row = "9Mobilzed", [Status]@row = "10COC- HR"), “green”))))

che.rabajante

Hello @Susan van Niekerk

Please try this:

Hope it helps!

che