30+ individual source sheet management
Answers
-
Hello,
Has anybody found solve for this? I have a similar issue. We have 30+ individual sourced sheets (which equivalent to each program we are working on), but no admin for the master sheet that can manually any new sheets that are created, so trying to figure out
- how to get all individuals sheets to link to 1 master
- create a metric dashboard from that master sheet to determine how many programs are being worked on at one point of time, manage timeline, and adoption vs. development ratio.
- when new sheets (programs) are created, is there a way for the new sheet to automatically link to the master?
Any suggestions or guidance would be greatly appreciated?
-
@Katrina_27 It sounds to me like you have an ideal use case for the add-on Control Center. Without it, you would need to leverage the API (or some other similar 3rd party app) or maintain everything manually.
-
You MAY be able to pull most of the metrics you need though by creating a row report and using grouping and summary fields within the report, but that depends on exactly what metrics you are anting to pull and how you want them displayed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives