Ownership

JenaW

It is frustrating when only the admin can make edits to a document. When I share a sheet to someone it say: Editor-can share, but this doesn't allow them to edit the sheet. Is there a way where multiple people can edit a sheet, not just the owner/admin?

Eric Law

Hello @JenaW

Editors should be able to make changes to cells, but not to column headers. Here is an article on all the rights a type of user has.

https://help.smartsheet.com/sharing-permission-levels

Zachary Hall

Hi,

There are several different levels of permissions to a document. Owners and Admins can create rows/columns, forms, automations, and more. Editors (both types) can edit data in the spreadsheet but not change the column types or add new columns. If they are an editor and can't make one of these changes, my first thought would be to check if the document is a report where they possibly don't have editor permission on the sheet that feeds the report.

I hope this helps.

JenaW

@Zachary Hall How do I make others admins too? It seemed to me like the owner is also the admin and nobody else can be? I want others to also be able to create rows/columns, forms, automations, and more. 

Zachary Hall

There should be an option when you share it above editor that is for an admin. (See picture below)

You can also edit the roles of people who already have access by clicking where it says Editor on the right and selecting a different role for them.

Here is a helpful article on permission levels with a lot more detail: https://help.smartsheet.com/articles/1155182-sharing-permission-levels

I hope this helps!

JenaW

@Zachary Hall Thank you!

I created reports that are located within folders. I want someone else to have full access to them, so I would make them the owner, but will they see the reports in the folders like I had created? I believe I have about 10-12 folders and I want them to see it how I see it because it is nicely organized.

Zachary Hall

@JenaW you would need to either:

1. share each of those reports to have it appear in a similar fashion
2. ensure these reports are in a Workspace and share permission with the whole Workspace

Workspaces are not available in all Smartsheet plans. You can find more info about them here: https://help.smartsheet.com/articles/2482797-workspace-navigation