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

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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 204 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives