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
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives