RGYB color change based on Status



I have gone through a lot of posts in this community and tried a bunch of formulas and can't get it to work.

I have 5 statuses in the Status column dropdown

  1. Not Started
  2. In Progress
  3. Delayed
  4. Behind
  5. Complete

I would like the RGYB colour to change based on the status.

  1. Not Started, and Complete - Blue
  2. In Progress - Green
  3. Delayed - Yellow
  4. Behind - Red

The most recent formula I tried, which I found in the discussion forum and it was working for the individual that posted is:

=IF(Status@row = "In Progress", "Green", IF(Status@row = “Delayed”, "Yellow", IF(Status@row = "Behind", "Red", IF(Status@row = "Complete", "Blue”, “Blue”))))

I continually get an unparsable error. Would greatly appreciate any and all assistance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!