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.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!