How to identify the unknown sheet

Tamsyn
✭✭✭✭
Hi there,
I am an admin on our company SS account.
One of our automation is not working, we think because there are too many formulas being used to reference on of our sheets.
Can anyone advise how to find out which sheet a range reference is set from as an administrator?
Thanks in advance
Answers
-
There is no way to determine this without already having access to the sheet that is referencing yours.
The only thing you can do would be to delete the reference from that other sheet and wait until someone reaches out about their sheet being broken.
-
Thanks @Paul Newcome I think we may have to delete the references and take it from there.
Appreciate your feedback.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives