RGYB color change based on Status

Options

Hi,

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!