Report from multiple sheets - but automatically including new sheets

We have three basic templates we may use to create a new WorkSpace. Each new WorkSpace represents a project and will have a sheet called "Transition Tracker". I'd like to run a report of information from each sheet in each WorkSpace (so across sheets), but also have it add new sheets as new Workspaces are created. Is that possible given the sheets will all be named the same or is the system not "smart" enough to automatically add new sheets?
Answers
-
The only way to have new sheets added to a report as they are created is to have all of those sheets in the same workspace and then select the workspace as the source for your report.
Would it be possible for you to create new folders inside of the same workspace instead of multiple workspaces?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives