Used in formula on: <unknown sheet>
Is there a way to see who the owner of the <unknown sheet> is? I'm have multiple sheets with data that is used for various metrics. I am currently looking at revamping those sheets but I have several columns that show:
Used in formula on: <unknown sheet>
I'd like to see who the owner of the unknown sheet is to notify them of the upcoming changes. Is there someplace I can look to find this?
Any help would be appreciated.
Thanks -Peggy
Best Answer
-
<unknown sheet> refers to a sheet that you are not shared on, so you won't be able to see the sheet name. Since you are not shared to the sheet, you won't be able to see who the Owner is either.
However, in order to create the formula looking at your sheet, the person who created the formula would need to be shared to this sheet as well. I would suggest reaching out to all the users shared to this current sheet to notify them of your changes, and perhaps request that they share this unknown sheet to you as well.
Cheers,
Genevieve
Answers
-
<unknown sheet> refers to a sheet that you are not shared on, so you won't be able to see the sheet name. Since you are not shared to the sheet, you won't be able to see who the Owner is either.
However, in order to create the formula looking at your sheet, the person who created the formula would need to be shared to this sheet as well. I would suggest reaching out to all the users shared to this current sheet to notify them of your changes, and perhaps request that they share this unknown sheet to you as well.
Cheers,
Genevieve
-
Thank you @Genevieve P.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives