Symbol to reflect variance from previous day
I am trying to create a formula where If the number from today is equal to the previous day, then the symbol will be yellow arrow, if it is less than the day before, it will be a green arrow and if it is greater than the day before, the arrow will be red. Any ideas?
Kristie Diersen 😀
Answers
-
If I understood you correctly then the formula will be:
=IF(Previous@row = Today@row, "Sideways", IF(Previous@row > Today@row, "Up", "Down"))
Tomasz Giba
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!