Can I use IF statements for symbols based on a dropdown column?


I've been trying all of the solutions from threads about symbols changing using IF statements, but none seem to be working.

I have a column called "Status" that is a dropdown and includes different application statuses like "Applied" and "Admitted". I want a different column called "Status bubble" to update the symbol GYRG (Green, Yellow, Red, Gray) based on the Status column.

Here is what I have been trying:

=IF([Status]@row = “Confirmed - IEP“, "Green", IF([Status]@row = “Applied”, "Yellow", IF([Status]@row = “Cancelled”, "Red", "Gray")))

and it keeps coming back #UNPARSEABLE.

Can anyone tell me what I am doing wrong? Does the IF statement not work with dropdown columns?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!