Keeping =TODAY() up to date even when the sheet is closed


Does anyone know if there's a way to get =TODAY() to automatically update without having to open the sheet it's on?

I have sheet summary formulas that update dashboard content, and these formulas are dependent on =TODAY() being correct and currently I'm having to open the source sheet every morning to get =TODAY() to update!

Thank you in advance.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!