RYG in Formula Gives Text as Answer
Options
Amber Jackson
✭✭✭✭✭
Hello Gurus!
I have the following formula that seems to be working well, except it is displaying the answer as text instead of the RYG ball:
My column type is set to symbols (specifically the RYG balls).
Any ideas?
Best Answer

The symbol column is case sensitive. Try "Red" instead of "RED".
Answers

The symbol column is case sensitive. Try "Red" instead of "RED".

@Paul Newcome you have saved my hide once again! Thanks so much sir!

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!