How to automatically have a report update when a new sheet is created in a workspace

Hello! I am trying to create an ongoing report/ chart with a workspace. So that anytime a new sheet is added to the workspace, it automatically updates the report, therefore updating the chart on the dashboard. I thought I had it figured out, but then one of our employees added a sheet to her workspace (outside of any folder, just a stand alone sheet), and it did not automatically update the report. I had to go into the report and re-click her workspace for it to update with the new sheet. Is there a way to just have this automatic so that anytime a new sheet is created in the workspace, it automatically updates?

Thanks in advance!

Find more posts tagged with

Workspaces

Reports

Accepted answers

All comments

Jason Tarpinian

Outside of Control Center, the only way to do this is the source for the report must be the workspace, not a folder or sheets. Doing this will then source all current sheets in the workspace, and any future sheets added (if you source a folder, it does not auto-add to reports). The caveat to this is to make sure your filters are set properly to not bring in obscure rows from sheets accidentally, like by setting the filter to - sheet name contains "Schedule", or something so it doesn't accidentally bring in data from a budget sheet.

sarato

EDIT: resolved

I have a similar issue, but I did make the source of my report a workspace and the report is not populating with new sheets added in the workspace. I will clarify that the sheets are nested in folders within the workspace, but that didn't seem to be an issue at report creation.

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.