I have a workbook with a worksheet, a large project that supports 8 different views.
Each view represents a subset of tasks from the larger project.
I’d like to invite people to individual views.
But want to keep the larger project and other views private. I only want them to view the sheet representing the tasks they are working on.
Unless I’m overlooking something, do not see a way to do this by inviting people to a view or even to a single sheet.
As work around:
If I were to make all views private,
could I invite a person for a single view,
Being restricted from all other views.
Thus maintaining confidentiality for the other views.
Do you think that would work?
This is a great workflow and use case for using (Private Views). Since the users would only have access to the Views that you have invited them to and if they are an “Editor” they cannot adjust any of the “Filters, Sorts, etc” then they can only edit the rows in their view.
Let us know how this works for your team!
Thanks Thomas, I try it.
So I’m OK with setting views private but the users are not actually Spreadsheet users at the moment. Can you outline the steps to acquire them as
And then inviting them to the specific view.
Do I do this at the Workbook level or do I invite from each view via permissions.
I’ve looked at user guide and not much help there. In any case, not exactly clear on how to proceed. A few screen snips with a comment or two should get me thru it.
May 18, 2023, 11:54pm
Happy to help with this and I’m including a short “Loom Video” to walk you through this.
Video Walkthrough (
here) View Permissions (
here) Sharing and Collaborating (
Please let me know if there are additional questions on this Martin.