How to automatically show a symbol

Nevin O'Regan

I have a status column which is a picklist field. The basic values of this picklist are pass / fail / on hold / retest. How can I manipulate the values that I can use in the symbol field?

Mike Wilday

You can write a custom if statement based on what symbol you want to use, So if someone picks "in progress" you could essentially create a symbol field with rgy balls and use the following formula: 

 

If([NameofDropDownField]2 = "in progress", "green", IF([NameofDropDownField]2 = "on hold", "yellow", "red"))

 

Then if the field in row 2 = "in progress"  you would see a green ball appear. or if it on hold a yellow ball would appear. If none of those words were in your field you would see red.

It's important to note that you would want to use the proper words depending on the symbol you are using. This tip from smartsheet shows you which language needs to be used for each type of symbol. https://www.smartsheet.com/blog/support-tip-column-symbols.