Date Formulas Do Not Auto Update?

Advm

I have several sheets with formulas calculating the difference between a given date and the current date. This formula only updates upon opening the sheet and then saving.

I have about 25 sheets, this means for the calculation to update daily, I need to open each of the 25 sheets to update each of their formulas. Is there a way to automate this process within SmartSheet? It is quite cumbersome having to do this every single day.

Andrée Starå

Hi @Advm

I hope you're well and safe!

Please look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Advm

I hope you're well and safe!

Please look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!