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
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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives