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