Dashboard widgets not updating

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.

Answers