NEW Help Article! Automatically update the TODAY function in formulas

Genevieve P.

Hi Community, 

Do you use the TODAY Function in any of your formulas? If so, there are a few different ways you can make sure this function is updated daily to reflect the current date without needing to open the sheet. 

Check out this NEW Help Article titled Automatically update the TODAY function in formulas that details four different solutions:

https://help.smartsheet.com/articles/2482767-automatically-update-today-in-formulas

Please feel free to leave your feedback on this article by using the "Was this article helpful" form to the right of the documentation:

🎉 Shout-out to @Andrée Starå who shared how he updated TODAY via this post in the Best Practice topic and provided guidance to others before the article existed! 

Don't forget you can nominate any great solution in the Community to be a Best Practice post by following the steps here. 

Cheers,

Genevieve

Mike S.

I have used these types of procedures for a few years now (since the record a date based on a schedule automation was released) but since about August, the today() function has stopped updating in many cases when using these and the only way it will update is when the sheet is opened. I have submitted tickets to Smartsheet and each time I am provided the information on how to trigger the today() function. Anyone else having this issue? Have you found a real solution besides eliminating the today() function all together?

Genevieve P.

Hey @Mike S. I saw your other post here and have responded to you on that thread. 🙂