When you share a sheet with someone, you can specify the sharing permission level with Viewer, Editor, or Admin level access to it. The permission level determines the features available to a collaborator for the item you're sharing (a sheet, report, or workspace for example). If you create an item, you are the Owner of that item.
In this article:
If you are looking for information about sharing permission levels for sharing a dashboard, please see Sharing a Smartsheet Dashboard.
The sharing permission level on a sheet isn't related to your account user type. For example, it's possible to be a System Admin on a multi-user account with only Viewer-level sharing access to a particular sheet; or, you could be a free collaborator with Admin-level sharing access to a sheet.
To learn more about the difference between permissions and account user types, see the visual guide Infographic: User Types and Sharing Permissions Explained or review our help article on User Types.Some features listed here are available only to licensed customers. Not sure whether you have a license? See Identify Your Smartsheet Plan and User Type.)
Sharing Permission Levels on Sheets
| Available Options | Viewer | Editor | Admin | Owner |
|---|---|---|---|---|
View all the sheet data, including comments | Yes | Yes | Yes | Yes |
Export a sheet | Yes | Yes | Yes | Yes |
Use the Save as New command to save the sheet as a new sheet | Yes | Yes | Yes | Yes |
| Send the sheet, or rows through email to themselves or others | Yes | Yes | Yes | Yes |
| Download attachments | Yes | Yes | Yes | Yes |
| Set own reminders and notifications | Yes | Yes | Yes | Yes |
| Sort rows and freeze columns for their own purposes, but can’t save these changes | Yes | Yes | Yes | Yes |
| Filter data in sheets with the "Unnamed Filter" | Yes | Yes | Yes | Yes |
| Apply saved filters (not available in single-user plan types) | Yes | Yes | Yes | Yes |
| Edit the sheet | No | Yes | Yes | Yes |
| Share the sheet | No | Yes | Yes | Yes |
| Edit unlocked rows and columns | No | Yes | Yes | Yes |
| Insert rows | No | Yes | Yes | Yes |
| Delete unlocked rows | No | Yes | Yes | Yes |
| Add new attachments and comments | No | Yes | Yes | Yes |
| Sort unlocked rows and freeze columns | No | Yes | Yes | Yes |
| Filter data in sheets, name filters to save them | No | Yes | Yes | Yes |
| Send Update Requests | No | Yes | Yes | Yes |
| Move rows within the sheet or to another sheet NOTE: If you move or copy rows to another sheet, the destination sheet must have the same column names as the source sheet. If the two sheets have different column names, the copy or move will create new columns. You must have a license and be shared to the destination sheet with Admin-level permissions to create new columns in it. For more information about moving rows, see Move Rows, Columns, or Cells. | No | Yes | Yes | Yes |
| Change the sharing permissions of other collaborators (for example, from Editor to Admin) | No | No | Yes | Yes |
Insert, rename & delete columns, change column properties (licensed Admins only) | No | No | Yes | Yes |
| Move columns within the sheet (licensed Admins only) | No | No | Yes | Yes |
| Share saved filters so that others can use them (not available in single-user plan types) | No | No | Yes | Yes |
Hide or unhide columns (licensed Admins only) | No | No | Yes | Yes |
Lock or unlock columns and rows | No | No | Yes | Yes |
Edit cells in locked columns or rows
| No | No | Yes | Yes |
Set alerts for others
| No | No | Yes | Yes |
Edit conditional formatting rules | No | No | Yes | Yes |
Create and manage forms (licensed Admins only) | No | No | Yes | Yes |
Enable dependencies on a project sheet:
| No | No | Yes | Yes |
Edit dependency settings | No | No | Yes | Yes |
Publish the sheet (business and enterprise only) | No | No | Yes | Yes |
Create and edit an automated update request or approval request rule. | No | No | Yes | Yes |
Delete a sheet or restore a deleted sheet | No | No | No | Yes |
Rename a sheet | No | No | No | Yes |
NOTE: Any collaborator with Admin access to a workspace will also have the ability to delete and re-name the sheets it contains. If a sheet is deleted from a workspace, it's recoverable for 30 days from the Admin and sheet owner's Deleted Items folder.
Sharing Permission Levels on Reports
| Available Options | Viewer | Editor | Admin | Owner |
|---|---|---|---|---|
Refresh and run the report to update its content | Yes | Yes | Yes | Yes |
| View all report data in all columns, including comments (if they're also shared to the underlying source sheets) | Yes | Yes | Yes | Yes |
| Export the report | Yes | Yes | Yes | Yes |
| Download attachments | Yes | Yes | Yes | Yes |
| Send the report through email to themselves or others More info> | Yes | Yes | Yes | Yes |
| Edit unlocked rows and columns (if they also have permission to the sheets) | No | Yes | Yes | Yes |
| Add new attachments and comments | No | Yes | Yes | Yes |
| Freeze columns | No | Yes | Yes | Yes |
| Enable or disable Highlight Changes | No | Yes | Yes | Yes |
| Share with others if allowed | No | Yes | Yes | Yes |
| Change the sharing permissions of other collaborators (for example, from Editor to Admin) | No | No | Yes | Yes |
| Edit unlocked rows and columns | No | No | Yes | Yes |
| Modify the Report Builder criteria | No | No | Yes | Yes |
| Sort the report | No | No | Yes | Yes |
| Add, rearrange, and remove columns from the report | No | No | Yes | Yes |
| Publish the report | No | No | Yes | Yes |
| Rename the report | No | No | No | Yes |
| Delete the report | No | No | No | Yes |
Reports in Workspaces
Anyone with Admin-permissions to a workspace will have the ability to delete and re-name the reports it contains. If a report is deleted from a workspace it's recoverable for 30 days from the Admin and sheet owner's Deleted Items folder.