Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Issue with Formula for RYBG Coded to Status
I am having issues with only one color in my formula for RYBG coded to the statuses I have. It appears Yellow always renders and invalid but the other colors do not. What am i missing in my syntax?
=IF(Status5 = "Complete", "Blue", IF(Status5 = "On Track", "Green", IF(Status5 = "Off Track", "Red", =IF(Status5 = "At Risk", "Yellow", ""))))