Restrict columns like a report but allow users to sort and filter
Hello, I need to provide my users with a limited view of a sheet (only the columns they are concerned with) while also allowing them to freely sort and filter. This is almost exactly what the Report feature does, but unlicensed users cannot sort or filter. How can I provide the functionality of restricting which columns are visible while also allowing a user to sort and filter?
I could generate the exact report that exact need with Power BI for example except they would not be able to actually edit it. It sounds like Dynamic View may be able to do this, but I am not 100% sure. Also, it is unlikely we can purchase a license for that since this would be the only project we would use it for.
Any thoughts? It is so remarkably close to being what we need, yet the small gap between what capabilities the Report offers versus what is needed make a huge difference. This small gap of functionality will definitely be enough to have to use a different platform or be unable to upgrade our process.
Thank you!
Answers
-
It sounds like a perfect use case for Dynamic View.
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!
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