Automate Direction Symbols

Patrick Dugan

I've got a calculated cell. As that cell changes, I'd like to automate the direction symbols to match the direction of change. i.e. If the value goes from .61 to .63, the "Up" arrow would show.

Possible?

Help?

Andrée Starå

Hi @Patrick Dugan

I hope you're well and safe!

Please have a look at my post below with a method I developed. (that could be modified to work for your use case)

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!