How do i get symbols to appear instead of the word representing a symbol?

edited 12/09/19 in Formulas and Functions


I am attempting to write an IF statement with the result being that the "Pilot Status" cell will have one of the symbols in it.

I have formatted the field to show symbols, and I've written the formula to use the representative words, but i'm still only seeing the word show up in the field.  HELP

My Formula is: =IF([Renewal Date]@row - TODAY() > 5, "yes", IF([Renewal Date]@row < TODAY(), "no decisions", "hold"))

AND as you can see in the screenshot, the cell is showing the WORD "hold" instead of the symbol it is supposed to represent.


Thanks in advance


Smartsheet - Symbols.PNG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!