Issue with Formula for RYBG Coded to Status

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


Best Answer

  • Accepted Answer

    Nvm figured it out. Its an extra = before my If statement

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Hasan,

    Glad you solved it!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Please help the Community by marking the post that helped answer your question or solve your problem with the accepted answer. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.