How to identify the unknown sheet
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives