Sheet Relationship Diagram

Is there a report I can create that will identify and map out all of the sheets that are linked to other sheets? We have hundreds of sheets, and quite a few workspaces. We regularly link one sheet to another so they all stay updated, but it can be hard to capture where everything is linked.

For example, we have a resources tracker sheet that tracks all of the staff involved with the project. It includes info about who their supervisor is, their job title, etc. We might link to that sheet to create other sheets, within different workspaces, to pull all of the people with the same job title, or that are in the same department. Is there a way to pull a report, or have an easy to access method to regularly check all of the assorted connections in one place?

Best Answer

Answers