Create a Report that Includes Newly Added Sheets Automatically?

Is there a way to have a report built off of ALL sheets in a workspace - so that when a new sheet is added, it will be included as well without manual manipulation?

Here is the use case: We have a project checklist that includes a expiration deadline date in each summary. All new projects added will have anew folder created with the same sheet and expiration date.

I want a report that will pull all sheets in each folder of the workspace and pull the expiration deadline. So if a new project folder and sheet is added it will automatically be added to the sheet?

Is this doable?

Find more posts tagged with

Reports

Accepted answers

All comments

Andrée Starå

Hi @Lindsey Digue

I hope you're well and safe!

If you reference the Workspace in the Report, all sheets current/future will be included automatically.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Lindsey Digue

Yup - probably should have tested this more thoroughly before asking :) This is perfect, thank you!

Andrée Starå

@Lindsey Digue

Excellent! Easy to miss!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

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.