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.
conditional symbol
Comments
-
Roberto,
Change the column to a Symbols type. There's several arrow images available.
Using the "4 directions" type (4 grey arrows), this would work
=IF([YourColumn]23, "Up", "Down")
where [YourColumn]23 is a placeholder for your expression, can be a checkbox or a value comparison, etc...
You can replace "Down" with another expression to make it a three way choice (good, bad, meh)
=IF([YourColumn]23=goodresult, "Up", IF([YourColumn]23,"Down","meh")
That is, you can show other results than the symbols chosen, but they won't have images associated with them.
Hope this helps.
Craig
-
Dear Roberto,
Yes, you can. Supposing you have a "Result" column and its value is "bad" if less than 5, otherwise "good" (and the value is in the first row):
=IF(Result1 < 5, "Down", "Up")
You are supposed to set the column type to "symbol", and select the red-green-yellow arrows.
Atus
-
Craig was faster
-
But you were more concise.
If I had more time, I could have been concise too (apologies to Blaise Pascal)
Craig -
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives