Outgoing Cell References
Is there any way to find where all outgoing cell references go?
What sheets, DataMesh, etc. are referencing a particular sheet, even if I don't have access to the requesting asset, what assets are using this sheet?
The activity log does not appear to show when formulas in other sheets reference the data. I can see when automation references it and who implemented the automation, but how do I find out if anyone has formulas referencing the sheet. Do we need to ask everyone with viewing rights and above?
Best Answer
-
Unfortunately I am not seeing a way to grab outgoing cross sheet references. Only incoming.
Answers
-
@ker9 hover over the cells with black outbound arrows to see references in other sheets. DataMesh you are out of luck and will have to check all mesh workflows.
Principal Consultant | System Integrations
Prime Consulting Group
Email: info@primeconsulting.com
Follow us on LinkedIn! -
@prime_nathaniel - thank you, I was doing that yesterday and nothing was happening. Today it works - it seems to be tricky when/where you hover.
Viewing the list involves scrolling. Impossibly difficult to do anything with it/capture the info. Can't be copied. No clue who owns these items so I'll need to capture them somehow (video?) and then match them using Sheet Access report.
There should be a better way to manage references.
-
Can an API get a list of the outgoing references?
What do you do with "unknown"?
-
The API should be able to give you some detail to include sheet, row, column ids, sheet name, etc..
-
@Paul Newcome - will an API list the outgoing references?
-
Unfortunately I am not seeing a way to grab outgoing cross sheet references. Only incoming.
