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
Hello,
I would like to know if it's possible to use a symbol linked to a result. For example: good result (up arrow) bad result (down arrow) automatically
Thank you
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 -
