Blank spreadsheet
A file was shared with me (with limited permissions), the owner set a filter to limit what can be seen of the file. However, when I go to view the spreadsheet I only see blank cells. I have no way of turning off the filter. What am I doing wrong?
Best Answer
-
Hi Joseph,
Do you know if the owner of the sheet set it up as a report? If it is a report and you cannot see the data, it's because you don't have permissions to see the underlying sheet.
The solution I have found to this is for me (as the owner) to create the report, then put the report on a Dashboard, and share the dashboard with the person. That way, I don't have to share the entire source sheet with them, but they can see the filtered data I want them to see.
Hope this helps!
Best,
Heather
Answers
-
Hi Joseph,
Do you know if the owner of the sheet set it up as a report? If it is a report and you cannot see the data, it's because you don't have permissions to see the underlying sheet.
The solution I have found to this is for me (as the owner) to create the report, then put the report on a Dashboard, and share the dashboard with the person. That way, I don't have to share the entire source sheet with them, but they can see the filtered data I want them to see.
Hope this helps!
Best,
Heather
-
That worked, thank you for the help!
-
Fantastic! Glad it worked for you.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives