Sheet Summary Metric on Dashboard



I have a dashboard with a normal metric widget that is linked to sheet summary data from the grid sheet. It works perfectly fine all day, then every morning shows "0" until I open the source sheet, click into the sheet summary tab and save the report. When I go back to the dashboard it is the value it is supposed to be even though I did not change or really do anything besides opening the source sheet.

Has anyone else experienced this issue or know if it may be something I have wrong rather than a bug? Thanks!!