Share Sheets, Reports, and Dashboards

Begin collaborating with others by sharing Smartsheet items (sheets, reports, and dashboards) or by confirming a team member's Request to be Shared

The best method to use for sharing will depend on the number of items you want to share and how many people you want to share with:

As an Owner or Admin, you can also apply a default view to an item to ensure that your collaborators immediately see the item information that is relevant to them. You can apply a default view to sheets, for example, so that a sheet opens to Card View first with a filter applied to show collaborators their assigned tasks. For more information on the process of creating filters, see our article on Using Filters to Show or Hide Sheet Data.

Permission Levels and Sharing

When you share an item with someone, that person will need to log in to Smartsheet to access it. You control what that person's level of access is through the sharing permission level you choose—Viewer, Editor, or Admin—when you share. You can stop sharing an item or change a collaborator's permission level at any time.

NOTE: System Admins of Team, Business, or Enterprise accounts can remove a user from sharing all items owned by the licensed users on the account.

Sharing Reports: You Must Also Share Source Sheets 

If you find that a report looks different for you than it does for someone that you've shared it to, such as missing information or being blank altogether, you may not have shared all of the source sheets with them. (Or they may not have shared all of their source sheets with you.)

For security purposes, a report doesn't give access to sheets that haven't already been shared to a user. For example, you can share a report that looks across three sheets to a collaborator who only has access to one of them. When the collaborator opens the report, they'll only see rows pulled from the one sheet that's shared to them. If the collaborator isn't shared to any sheets, their version of the report will be blank.


Share Smartsheet Items

People shared with Owner, Admin, and Editor - Can Share permissions have the ability to share Smartsheet items.

NOTE: If the item is located in a workspace, you can either share it individually or share the entire workspace. For more information, see Sharing an Item from a Workspace later in this article.

  1. Click the Share button at the top of the the item.

    share-button
    If you don't see the Share button, click the down arrow icon in the upper-right of the Smartsheet window.
    show-menu-bar-sharing
    The sharing form will be displayed. If the item isn't shared with anyone, you'll see the Invite Details.
    Sheet Sharing form

    If others are currently shared, you'll see a list of existing Collaborators appear by default. (You can alway click Invite Details if you want to see those instead.)
    Sharing window

    TIP: All shared collaborators can use the secure sheet link to open it directly—consider bookmarking the link for quick access to the item. When using the link, you'll be prompted to log in to Smartsheet (if you aren't already) in order to access the sheet.

  2. In the Invite Collaborators box at the top, type the email addresses of the people or groups you want to share the item with. Separate multiple email addresses with a comma or semicolon.
  3. Select a Permissions level. For a detailed breakdown of features available to each permission level, check out the Sharing Permission Levels article.
  4. Click Share.

The collaborators will be shared to the item and will receive a notification if you opted to send one. The Sharing form will be updated to display the list of shared Collaborators including those you just added.

Once your items are shared, you may want to learn more about Working with Multiple Collaborators.


Share an Item from a Workspace

When a sheet, report, or dashboard exists in a workspace, it will be available to anyone who has sharing permissions for the workspace. Even when it's in a workspace, the item can be shared at the item level so that people who don't have access to the workspace can still have access to the item.

You must have Owner, Admin, or Editor - can share permissions to the item in order to share it. (Similarly, to share a workspace, you'll need Owner, Admin, or Editor - can share permission to the workspace.)

Here's how you can give someone access to an item that's located in a workspace:

  1. Click the Home tab (the left-most tab in Smartsheet).
  2. Under Workspaces, click the workspace where the item resides.
  3. Right-click the item name and click Share to open the Sharing form.
  4. Click in the Invite Collaborators box and type or select contacts.

    You'll see the This sheet, report, or dashboard is in a workspace text. If you have permissions to the workspace, you'll also see the name of the workspace.

    Sheet Sharing form, This sheet is in a workspace circled
     
  5. To share the item only, click Share. To share the workspace, click Share Workspace.

When items and workspaces are shared, you'll see the Workspace Sharing imageShared to Sheet, Report, or dashboard via workspace icon and the Shared to Sheet Only icon Shared to Sheet, Report, or dashboard only icon next to the permission levels in the Collaborators section of the sharing form. These icons can help you distinguish how the item has been shared with the various collaborators.


Set a Default View

As the item Owner or an Admin, you can ensure that anyone shared to your sheet sees the sheet as you've intended by applying a default view and filter. Set a default view, for example, for newly shared collaborators to open a sheet directly to Card View with a filter applied to show only high priority tasks.

NOTE: You'll need to create a saved filter before setting a default filter. For more information about creating filters, see our article on Using Filters to Show or Hide Sheet Data.

To set a default view on your sheet:

  1. Click the Share button at the top of the the item to display the Sharing window.
    Sharing window
  2. Select Collaborators to display the list of current Smartsheet users shared on the sheet.
     
  3. To the right of Default View, select Edit.

    The Default View form appears.

    default view
     
  4. Under View, select Grid View, Card View, Gantt View, or Calendar View. You can also select a default filter and specific Card View lanes, if desired.

    NOTE: You'll need to create a shared filter before you can set a default filter. For more information about creating filters, see our article on Using Filters to Show or Hide Sheet Data.
     
  5. Click Save.

Remove a Collaborator or Change Permission Levels

The item owner and collaborators with Admin access to the item have the ability to remove others or change their permission levels. Editors may also have this ability if they were given permission to share the item when they were invited.

  1. Click the Share button at the top of the the item.

    If you don't see the Share button, click the down arrow icon in the upper-right of the Smartsheet window.
    show-menu-bar-sharing

  2. In the Sharing form, mouse-over the name of the person you'd like to remove or change to highlight the row and do either of the following:
    • Change Permissions: Select a new permission level from the drop-down list. Note that you can't give another collaborator a higher access level than you have yourself (that is, someone with Editor-level permissions can't promote another person with Editor-level permissions and give them Admin-level access).
       
    • Remove from Sharing: Click the X at the right end of the permission level row.

      The person will no longer have access to the item. If you stop sharing with someone at the time that they are viewing the item, they'll will receive an error message at the next save or refresh.

      NOTE:  If you see the Workspace Sharing imageShared via workspace icon next to the permission level for a collaborator, that means that the collaborator has access to the item via a workspace. Clicking X will remove the collaborator's permissions from the workspace. For more information about sharing a workspace, see Workspace Sharing.

      In the  Collaborators section, notice the Workspace Sharing image Shared via Workspace icon or the  Shared to Sheet Only icon Shared to...only icon next to the permission levels. These will help you distinguish how the item has been shared with the various collaborators.

Group Admins on Team and Enterprise plans can remove a member from a group to also remove them from all items that are shared to that group.


Request to be Shared

In some cases, you may attempt to open an item and will see a "You could not open...because it is not shared with you..." message.



Common reasons for seeing this message include:

  • A sharing link was forwarded to you but your email address isn't shared to the item
  • You're logged into Smartsheet with an email address that is different from the one the email was sent to
  • The item owner or another collaborator has removed you from sharing
  • The item has since been deleted

If you'd like to access an sheet, report, dashboard, or workspace that isn't shared to your email address, click the Request Access from Owner button in the message. This will send an email to the item or workspace owner with a confirmation link they can click to select a sharing permission level for your email address. Once the item or workspace owner has completed this process you’ll be able to access the item (either use the link you received or find the sheet in Smartsheet directly).

Back to top

Was this article helpful?
YesNo