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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives