Formula for symbols


Hello team,

I have created a Health column that is dependent on the project status column. Chose properties to be symbols red, yellow, green, blue. I have created the formula below but the results returned are spelling out the colour name when I want the symbol.

What am I doing wrong? 😔

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!