Update Cell to show current trend arrow for current month

Giovanni_64 ✭✭
edited 12/06/22 in Formulas and Functions

Hey Community!

I have not been able to find a viable solution to what I am trying to create.

I have a repository sheet that keeps track of current data. In this sheet, I show trend arrows that show "Sideways," "Up," and "Down" depending on the data entered.

Now I'm attempting to figure out how to display this trend arrow in the highligted cells below, that are only relevent to the current month for the correlated column.

The purpose of this is to enable me to reference this cell in a different report sheet so that it will always display the current trend without requiring me to manually alter it for the current month.

Thank you, for any responses in advance! :)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!