Sheet sharing - some rows only

Lauren Y

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.

Paul Newcome

Have you looked into the premium add-on Dynamic View?

Paul Newcome

Have you looked into the premium add-on Dynamic View?

Lauren Y

I haven't - but looking now! thank you

Paul Newcome

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.