Change Permissions for Specific Items in Workspace

It would be very helpful if I could override workspace permissions for specific items in a workspace. For example:

I give a bunch of people Editor permissions at the workspace level, but for one sheet inside the workspace, I want to downgrade their permissions to Viewer. My understanding is that this is not currently possible.

Thank you for considering this idea.

Sign in to vote!

Find more posts tagged with

Idea Submitted

Comments

Genevieve P.

Hi @George Speier

Thank you for posting your idea! You are correct that you cannot downgrade sharing permissions on a specific sheet within a workspace, however you can do the opposite:

Provide your users with Viewer Permissions in the Workspace
Add them separately to any sheets you want them to have Editor or higher permissions

The higher permission level will override the lower Workspace one so they'll be able to edit specific sheets, but the default permissions for newly created items in that Workspace will be Viewer.

Cheers,

Genevieve

George Speier

@Genevieve P. Thank you. Unfortunately, that's a very unappealing solution when you have a very long (and growing) list of sheets that need to be editable by everyone, and only one or two sheets that need to have their permissions downgraded.

dizzy_brain

@Genevieve P. I just tried what you suggest and it didn't work. I gave user view permission to the workspace. I then went into a sheet within a folder, selected the same user and wanted to give them editor rights but it immediately made that person editor for entire workspace. What am I doing wrong?

dizzy_brain

https://community.smartsheet.com/discussion/comment/414661#Comment_414661

I have an update: it weirdly seems to do with the order of permissions granting. If a user has no permission at all at a workspace, I can give them edit permission to a sheet, followed by a view permission to entire workspace. This works - they become an editor of a sheet, with a view permission to the rest of the workspace. If a user already has a view permission to a workspace, then trying to give them edit permission to a sheet insists on changing their permission to editor to the entire workspace. Kind of tedious.

Genevieve P.

Hi @dizzy_brain

Can you clarify what button you're clicking when you share the direct item? You will need to entirely re-share that same user to the individual sheet, versus updating their permission levels.

Meaning if you already have someone listed as shared to the Workspace (with the Workspace icon next to them):

You'll need to re-type in their email or contact information at the top to add them for a second time:

And this time click "Share" instead of "Share to workspace". Let me know if this makes sense and works for you!

Cheers,

Genevieve

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…