Sharing permissions on sheets, reports, or workspaces

 = included

  = 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

Delete locked rows

x x x

Insert rows

x x

Insert, rename and 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 can 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 don’t 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 themselves

Create and edit sheet-level reminders for themselves*

Create and edit automated workflows (for example: approval requests and automated update requests)*

x x x

Can disable or delete any automated workflows for themselves*

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