Greater Than, Less Than, or Equal To previous month value

Hello,

I'm looking for help with the following formula to show trending information.

12 Months of Data (Jan - Dec), When each month gets updated, I would like to use a formula to show symbols for trending up, down, or unchanged compared to the previous month.

Does anyone know of a formula that can point me in the right direction?


Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!