Automated symbol update when date changes

Maida Omerovic

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!

Ryan Sides

Hi @Maida Omerovic , you would need a static place for your original date (this could be a Sheet Summary field or a cell on your main sheet area) . Then create a IF formula in the Symbol column to compare these two dates.

Ryan Sides

Hi @Maida Omerovic , you would need a static place for your original date (this could be a Sheet Summary field or a cell on your main sheet area) . Then create a IF formula in the Symbol column to compare these two dates.

Maida Omerovic

Thank you very much, @Ryan Sides, it worked perfectly.

Ryan Sides

Great! Glad you got it working.