Dashboard widgets not updating

Kacy Hayes

I am having the same issue across multiple workspaces that just started recently. I have dashboards that are displaying metrics from the summary of the source sheet. The data to the source sheet is input via form so no one goes into the source sheet regularly. Recently the widgets on the dashboard are not updating unless you go into the source sheet and save it. Once you do this the dashboard updates.

I have read similar problems and adding helper date columns but this is not something I would prefer to do. I have also been running these dashboards for 2 years without this issue.

brianschmidt

https://community.smartsheet.com/discussion/119577/dashboard-widgets-not-updating

I have had the same issues and have been hunting for a solution. Here's a thread that proposes a solution you could try: https://community.smartsheet.com/discussion/78008/report-not-updating-formula-unless-the-underlying-sheet-is-opened-and-refreshed

I am yet to try it. So, if it works for you, please do let me know!:)