Dashboard Widget Updates - by Week


I have created a Master Smartsheet which I am using to create my dashboard. My Master Sheet is displaying collated values for each week of the year taken from other reference sheets.

I have created the widgets for Week 49 which I believe will remain static until I manually update to display Week 50 values.

Can you advise if there is a way for these values to automatically update to Week 50, Week 51 and so forth on my dashboard.

I have attached a copy of same along with the formulas used for calculating the values.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!