Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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)
