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?