Dashboard Update Automatically Daily

Hello,

I'm having issues with a dashboard I have set up, not updating information from a sheet until that sheet is opened/refreshed.

I currently have a sheet with rows of names and corresponding dates; basically, shift schedules by day. I then pull whatever names correspond to today's date into a sheet summary and have a report to pull that sheet summary information. That report is then used to populate a dashboard.

The problem is that the dashboard is not updating overnight, even though when I open the sheet that the information is coming from the information is automatically updating and showing the correct data.

Is there a way to automatically refresh the source sheet without opening it? Hopefully that makes sense, please let me know if you need any other information or any screenshots.

Thank you!

Find more posts tagged with

Formulas

Reports

Dashboards

Sheet Summary

Accepted answers

All comments

kowal

hi @Spencer_W,

i think this could be a bug as the dashboards update automatically when the data in sheets/ summary sheet updates.

Spencer_W

Hello @kowal,

I thought that might've been the case, I just wanted to make sure I wasn't missing something before I submitted a bug report.

Thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.