conditional symbol

Roberto Simões

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

J. Craig Williams

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

 

 

Atus Bartal

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

Atus Bartal

 Craig was faster

J. Craig Williams

But you were more concise.

 

If I had more time, I could have been concise too (apologies to Blaise Pascal)

Craig

Atus Bartal