Formula for symbols
Options
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
-
The names are case sensitive. Try capitalizing the first letter in each of the colors.
Answers
-
The names are case sensitive. Try capitalizing the first letter in each of the colors.
-
It worked! Such a simple change put the biggest smile on my face - thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!