Issue with Formula for RYBG Coded to Status

Hasan Syed

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

Hasan Syed

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

Hasan Syed

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

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!