Column Properties using Symbols

To reference the symbols in a formula, you need to use the text value. To find that, you can simply click the arrow for the dropdown box. It will have the symbol on the left and the corresponding text value on the left. It is case sensitive and has to be "wrapped in quotes". 

In the below image you will see what I mean. So to use the top one I will use a basic IF statement as an example.

What I want the IF statement to do (note bold, italic, and underline to show each portion of the formula), is IF a full smiley is selected (no pain), then I want this other cell (the one I'd put the formula in) to populate with the text of "GREAT!!!". If something else is selected (or nothing at all), I want it to remain blank.

=IF(Status@row = "No Pain", "GREAT!!!", "")

This can be used for almost every set of symbols. Just select the cell and look at the text value. Certain symbols that only have 2 options such as the single star or the flag will use 1 for checked/flagged and 0 for not in the same way a checkbox column is referenced.

Always happy to help.