IF statement to return an arrow?
Hello, I am trying to get Smartsheet to return an arrow if a certain cell's value is greater than, equal to, or less than zero. I wrote this function to do this but it does not results in anything:
=IF([Change in cFTE]@row < 0, "Down", IF([Change in cFTE]@row = 0, "Unchanged", IF([Change in cFTE] 0, "Up", "Blank")))
I'd like the function to return an Up arrow if the value is greater than 0, a sideways arrow if it's equal to 0, and a down arrow if it's less than 0.
How can I do this?
Help Article Resources
Check out the Formula Handbook template!