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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!