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

Options
mjandorf
mjandorf
edited 12/09/19 in Formulas and Functions

Hi,

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

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!