Smartsheet sharing permissions
✓ = included
x = not included
Sharing permission levels on sheets
Sheet management
Available options |
Viewer |
Commenter |
Editor |
Admin |
Owner |
---|---|---|---|---|---|
View all sheet data, including comments |
✓ | ✓ | ✓ | ✓ | ✓ |
Edit unlocked rows and columns in a sheet |
x | x | ✓ | ✓ | ✓ |
Edit cells in locked columns or rows* |
x | x | x | ✓ | ✓ |
Insert rows |
x | x | ✓ | ✓ | ✓ |
Insert, rename & delete columns, change column properties* |
x | x | x | ✓ | ✓ |
Move columns within a sheet* |
x | x | x | ✓ | ✓ |
Hide or unhide columns* |
x | x | x | ✓ | ✓ |
Move rows within a sheet |
x | x | ✓ | ✓ | ✓ |
Move rows to another sheet |
x | x | ✓ | ✓ | ✓ |
Lock or unlock columns and rows* |
x | x | x | ✓ | ✓ |
Delete unlocked rows |
x | x | ✓ | ✓ | ✓ |
Edit conditional formatting rules* |
x | x | x | ✓ | ✓ |
Enable or disable Highlight Changes in a sheet or report |
x | x | ✓ | ✓ | ✓ |
Export a sheet or report |
✓ | ✓ | ✓ | ✓ | ✓ |
Sort unlocked rows and freeze columns without saving |
✓ | ✓ | ✓ | ✓ | ✓ |
Sort locked rows |
x | x | x | ✓ | ✓ |
Save changes after sorting rows or freezing columns |
x | x | ✓ | ✓ | ✓ |
Add new attachments and comments in a sheet or report |
x | ✓ | ✓ | ✓ | ✓ |
Download attachments in a sheet or report |
✓ | ✓ | ✓ | ✓ | ✓ |
Filter data in sheets with the "Unnamed Filter" |
✓ | ✓ | ✓ | ✓ | ✓ |
Name filters to save them |
x | x | ✓ | ✓ | ✓ |
Apply saved filters (not available for Pro plan) |
✓ | ✓ | ✓ | ✓ | ✓ |
Create, edit, and delete shared filters (not available for Pro plan)* |
x | x | x | ✓ | ✓ |
Use the Save as New command to save the sheet as a new sheet* |
✓ | ✓ | ✓ | ✓ | ✓ |
Save a sheet as a template* |
✓ | ✓ | ✓ | ✓ | ✓ |
Rename a sheet or report |
x | x | x | x | ✓ |
Delete a sheet or report/restore a deleted sheet or report |
x | x | x | x | ✓ |
Create a connection from a sheet to a DataTable |
x | x | x | ✓ | ✓ |
Any collaborator with Admin access to a workspace will also have the ability to delete and rename the sheets it contains. If a sheet is deleted from a workspace, it's recoverable for 30 days from the sheet owner's Deleted Items folder. Admins can see the item in their folder, but do not have permission to recover the item.
*Available only to licensed users
Collaboration
Available options |
Viewer |
Commenter |
Editor |
Admin |
Owner |
---|---|---|---|---|---|
Share a sheet or report |
x | x | ✓ | ✓ | ✓ |
Change the sharing permissions of other collaborators (for example, from Editor to Admin) |
x | x | x | ✓ | ✓ |
Send a sheet or report via email to self or others |
✓ | ✓ | ✓ | ✓ | ✓ |
Send rows via email to self or others* |
✓ | ✓ | ✓ | ✓ | ✓ |
Publish a sheet or report (business and enterprise accounts only)* |
x | x | x | ✓ | ✓ |
Create and manage forms* |
x | x | x | ✓ | ✓ |
Send and edit Update Requests* |
x | x | ✓ | ✓ | ✓ |
*Available only to licensed users
Automation
Available options |
Viewer |
Commenter |
Editor |
Admin |
Owner |
---|---|---|---|---|---|
Create and edit row-level reminders for other sheet collaborators |
x | x | x | ✓ | ✓ |
Create and edit sheet-level reminders for other sheet collaborators |
x | x | x | ✓ | ✓ |
Create and edit row-level reminders for themself |
✓ | ✓ | ✓ | ✓ | ✓ |
Create and edit sheet-level reminders for themself* |
✓ | ✓ | ✓ | ✓ | ✓ |
Create and edit automated workflows (for example: approval requests, and automated update requests)* |
x | x | x | ✓ | ✓ |
Can disable or delete any automated workflows for themself* |
✓ | ✓ | ✓ | ✓ | ✓ |
Can disable or delete any automated workflows for other sheet collaborators* |
x | x | x | ✓ | ✓ |
*Available only to licensed users
Project management
Available options |
Viewer |
Commenter |
Editor |
Admin |
Owner |
---|---|---|---|---|---|
Enable dependencies on a project sheet* |
x | x | x | ✓ | ✓ |
Edit dependency settings* |
x | x | x | ✓ | ✓ |
*Available only to licensed users
Sharing permission levels on reports
Available options |
Viewer |
Commenter |
Editor |
Admin |
Owner |
---|---|---|---|---|---|
View all report data in all columns, including comments (if the user is also shared to the underlying source sheets) |
✓ | ✓ | ✓ | ✓ | ✓ |
Refresh and run the report to update its content |
✓ | ✓ | ✓ | ✓ | ✓ |
Edit unlocked rows and columns (if the user also has editing permission in the source sheets) |
x | x | ✓ | ✓ | ✓ |
Freeze columns |
x | x | ✓ | ✓ | ✓ |
Modify the report builder criteria* |
x | x | x | ✓ | ✓ |
Sort the report* |
x | x | x | ✓ | ✓ |
Rearrange columns |
x | x | x | ✓ | ✓ |
Add and remove columns* |
x | x | x | ✓ | ✓ |
*Available only to licensed users