How can I change permissions of a sheet within a Worskpace without changing permissions of the entir

Megan Wray

I have a sheet that I want to retain sole editing rights to, and allow others to view.

I shared it to a project workspace. However, now that sheet matches the sharing permissions of the entire workspace, and when I try to change them, I get a message "this will change the user's permissions to the entire workspace." 

How can I keep a sheet within a workspace, so all project sheets are all together, but assign permissions different than the entire workspace?

J. Craig Williams

It is possible, but it is ugly.

 

If the person is shared to the workspace, then their permissions are for everything IN the workspace. You can't have a "default" permission of Viewer but give them Admin provileges for only one sheet, for example.

 

However, a user NOT shared to the workspace could be given access to everything IN the workspace with different permissions for each - as long as they are only shared to sheets and not the workspace.

 

And you could do that for every person and every sheet.

Only the workspace Owner would have be shared at the workspace level.

Everyone else, one at a time, shared to the sheets and reports.

 

Ick.

 

But possible.

 

You could make this a little more palatable by sharing by Group instead of individual

(so for 20 sheets and 20 users, you could perhaps only have 4 groups and so only need to share 80 times instead of 400)

 

Still Ick.

But only 20% Ick.

 

Craig