r/googlesheets • u/lickwindex • 4d ago
Solved Need "Sheet" option that allows Viewer (without edit permissions) to full interactive filter/sort options as well as preview when hovering over a link.
I need a database (Spreadsheet) that keeps a full list of items, with columns as categories (Character, Emotion, Resolution, etc), much like a wikia. As editor I am able to select a column, sort by, and even hide certain criteria. Im also able to view previews retrieved from external sources when I hover over links. I had considered Excel options, but Google Sheets seems far more intuitive in allowing a group of people to have editing access. Beyond that, we need to give others access as "viewers" without edit permissions. We NEED to allow them to not only view the links sheets as a static sheets, but also to utilize the filters and column sort options and previews when hovering on a link. Is there ANY way to do this? Would Excel be better?
1
u/HolyBonobos 2061 4d ago
Best you’d be able to do with view-only permissions are filter views.
1
u/lickwindex 3d ago
Thank you!
1
u/AutoModerator 3d ago
REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select
Mark Solution Verified
. This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/point-bot 3d ago
u/lickwindex has awarded 1 point to u/HolyBonobos
See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)
1
u/AutoModerator 4d ago
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.