Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

How to automatically show a symbol

Nevin O'Regan
edited 12/09/19 in Archived 2017 Posts

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?

Comments

  • Mike Wilday
    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.

This discussion has been closed.