Automated symbol update when date changes

Hello -

I am wondering if there is a way to automatically update symbols up, unchanged, or down should the date change in the course of the project. i.e. if the original date for an activity is 2/28/2023 and changes to 2/20/2023, the symbol would automatically change to up. if date remains, than it will remain unchanged, and if changed to 3/1/2023, the symbol would automatically change to down.

thank you for your help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!