Countdown to future date not updating when sheet isn't opened


Hi All,

I'm using the following formula to add a date countdown metric to a portal.

=DATE(2022, 12, 1) - TODAY()

The issue I'm having is that it's not updating unless the metrics sheets that I have the formula in is opened.

Does anyone have a work around for this?

Many thanks,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!