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)
