Sheet sharing - some rows only
Is there a way to share just rows of a sheet (i.e., filter out sensitive information)that also allows someone to either comment or complete a field?
Right now, we are linking applicable rows to another sheet and sharing with them which is quite inefficient. We are also doing this via cell link which isnt great if something changes.
Dashboards wont work because we need to allow them to comment on their portion.
Best Answer
-
Have you looked into the premium add-on Dynamic View?
Answers
-
Have you looked into the premium add-on Dynamic View?
-
I haven't - but looking now! thank you
-
Happy to help. 👍️
You can create a filter by user within the dynamic view or filter however else you need in the sheet and then leverage this filter in the dynamic view. From there you would share your users to the Dynamic View (not the sheet) to allow them to update fields, see some as read only, hide fields based on the filter in place without giving them access to the underlying sheet where they would be able to see everything.
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