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?

Find more posts tagged with

Activity Log

References

Accepted answers

Paul Newcome

Unfortunately I am not seeing a way to grab outgoing cross sheet references. Only incoming.

All comments

prime_nathaniel

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

ker9

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

ker9

Can an API get a list of the outgoing references?

What do you do with "unknown"?

Paul Newcome

The API should be able to give you some detail to include sheet, row, column ids, sheet name, etc..

ker9

@Paul Newcome - will an API list the outgoing references?

Paul Newcome

Unfortunately I am not seeing a way to grab outgoing cross sheet references. Only incoming.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.