30+ individual source sheet management

System

This discussion was created from comments split from: How to combine & link multiple source sheets into one master sheet?.

Katrina_27

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

1. how to get all individuals sheets to link to 1 master
2. 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.
3. 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?

Paul Newcome

@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.

Paul Newcome

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.