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

mjandorf

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

 

Andrée Starå

Hi,

It's not working because you have to write it like Yes No Hold

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

mjandorf

THANK YOU...it worked!

Andrée Starå

Excellent!

Happy to help!