Using today() in formulas
I have a smartsheet that has some values calculated using a formula containing today(). Everything works fine on my dashboard when I use this, but I have found the dashboard becomes stall unless I open the smartsheet up to let the today() function update with the current date. Is there a way to use this so that it will stay up to date without opening the smartsheet? Is there something I could run daily that would update this without having to go into the smartsheet. I created the smartsheet and form for others to use, but with the intent of them not having to ever open the smartsheet. I don't want to constantly have to open the smartsheet to let the formulas update to the current date every day.
Help Article Resources
Check out the Formula Handbook template!