Sharing permissions on sheets, reports, or workspaces

 = included

  = not included

Sharing permission levels on sheets

Sheet management

Available options
Viewer
Commenter
Editor
Admin
Owner
Plan Asset Admin
View all sheet data, including commentsx
Edit unlocked rows and columns in a sheetxxx
Edit cells in locked columns or rowsxxxx
Delete locked rowsxxxx
Insert rowsxxx
Insert, rename and delete columns, change column properties*xxxx
Move columns within a sheet*xxxx
Hide or unhide columns*xxxx
Move rows within a sheetxxx
Move rows to another sheetxxx
Lock or unlock columns and rows*xxxx
Delete unlocked rowsxxx
Edit conditional formatting rules*xxxx
Enable or disable Highlight Changes in a sheet or reportxxx
Export a sheet or reportx
Sort unlocked rows and freeze columns without savingx
Sort locked rowsxxxx
Save changes after sorting rows or freezing columnsxxx
Add new attachments and comments in a sheet or reportxx
Download attachments in a sheet or reportx
Filter data in sheets with the Unnamed Filterx
Name filters to save themxxx
Apply saved filters (not available for Pro plan)x
Create, edit, and delete shared filters (not available for Pro plan)*xxxx
Use the Save as New command to save the sheet as a new sheet*x
Save a sheet as a template*x
Rename a sheet or reportxxx
Delete a sheet or report/restore a deleted sheet or reportxxx
Create a connection from a sheet to a DataTablexxxx

 

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
Plan Asset Admin
Share a sheet or reportxxx
Change the sharing permissions of other collaborators (for example, from Editor to Admin)xxx
Send a sheet or report via email to self or othersx
Send rows via email to self or others*x
Publish a sheet or report (Business and Enterprise accounts only)*xxxx
Create and manage forms*xxxx
Send and edit Update Requests*xxx

*Available only to licensed users

 

Automation

Available options
Viewer
Commenter
Editor
Admin
Owner
Plan Asset Admin
Create and edit row-level reminders for other sheet collaboratorsxxxx
Create and edit sheet-level reminders for other sheet collaboratorsxxxx
Create and edit row-level reminders for themselvesx
Create and edit sheet-level reminders for themselves*x
Create and edit automated workflows (for example: approval requests and automated update requests)*xxxx
Can disable or delete any automated workflows for themselves*x
Can disable or delete any automated workflows for other sheet collaborators*xxxx

*Available only to licensed users

 

Project management

Available options
Viewer
Commenter
Editor
Admin
Owner
Plan Asset Admin
Enable dependencies on a project sheet*xxxx
Edit dependency settings*xxxx

*Available only to licensed users


Sharing permission levels on reports

Available options
Viewer
Commenter
Editor
Admin
Owner
Plan Asset Admin
View all report data in all columns, including comments (if the user is also shared to the underlying source sheets)x
Refresh and run the report to update its contentx
Edit unlocked rows and columns (if the user also has editing permission in the source sheets)xxx
Freeze columnsxxx
Modify the report builder criteria*xxxx
Sort the report*xxxx
Rearrange columnsxxxx
Add and remove columns*xxxx

*Available only to licensed users