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?
Best Answer
-
I think "Blank" was your issue. Try this:
=IF([Change in cFTE]@row < 0, "Down", IF([Change in cFTE]@row = 0, "Unchanged", IF([Change in cFTE]@row > 0, "Up", "")))
NOTE: If your Change in cFTE column is blank, the formula will select Unchanged. It appears to be reading blank as Zero. So if you really want a blank to give you a blank in that column, try this...
=IF([Change in cFTE]@row < 0, "Down", IF(ISBLANK([Change in cFTE]@row), "", IF([Change in cFTE]@row = 0, "Unchanged", IF([Change in cFTE]@row > 0, "Up", ""))))
Answers
-
I think "Blank" was your issue. Try this:
=IF([Change in cFTE]@row < 0, "Down", IF([Change in cFTE]@row = 0, "Unchanged", IF([Change in cFTE]@row > 0, "Up", "")))
NOTE: If your Change in cFTE column is blank, the formula will select Unchanged. It appears to be reading blank as Zero. So if you really want a blank to give you a blank in that column, try this...
=IF([Change in cFTE]@row < 0, "Down", IF(ISBLANK([Change in cFTE]@row), "", IF([Change in cFTE]@row = 0, "Unchanged", IF([Change in cFTE]@row > 0, "Up", ""))))
-
Thank you! This was the solution, I was able to get this to work with your formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 205 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!