Applies to

Smartsheet Advance Package

Capabilities

Who can use this capability

To use DataTable:

  • You must have Owner or Admin permissions on any sheets where a DataTable Connection will be built.
  • DataTable must be a premium application available on the plan.
  • You must have DataTable Premium Application permissions enabled in User Management by your Smartsheet System Admin.

To check your access level, log in to DataTable.

Visit the DataTable Marketplace page to learn how to contact your Sales representative for pricing-related inquiries

Manage existing DataTables

Learn how to manage your existing DataTables.

PLANS

  • Smartsheet Advance Package

Permissions

To use DataTable:

  • You must have Owner or Admin permissions on any sheets where a DataTable Connection will be built.
  • DataTable must be a premium application available on the plan.
  • You must have DataTable Premium Application permissions enabled in User Management by your Smartsheet System Admin.

To check your access level, log in to DataTable.

Visit the DataTable Marketplace page to learn how to contact your Sales representative for pricing-related inquiries

If you're an admin on DataTable, you can share a DataTable with others in your organization, granting either admin or viewer access. If you created the DataTable, you are already an admin; you can create additional admins or viewers.

Log in to DataTable

You can manage all your DataTables to perform actions, such as the following:

  • View all of your DataTables and DataTables you’ve been shared to
  • Share your DataTables
  • View, edit, and delete all sheet connections
  • View and filter the data in a DataTable
  • Add, edit, and delete fields in a DataTable

DataTable permission levels

Admins can:

  • View, edit, and delete a DataTable
  • View, edit, create, and delete records on a DataTable
  • Modify permissions on a DataTable
  • Manage DataTable connections 
  • Create Data Shuttle workflows.

Viewers can:

  • View the DataTable
  • View records in the DataTable
  • Manage DataTable connections

Smartsheet System Admins can add and remove Admins and Viewers for all DataTables in an organization. To view all DataTables, the System Admin can toggle View all in the DataTable list view. A System Admin can share a DataTable with any other licensed user on the plan, preventing DataTables from being left without an owner.


Manage DataTable connections

There are two ways to access existing connections:

  • In the sheet, go to the Connections and select your DataTable.

  • On the left navigation, select Browse and then select DataTables.

Delete a connection

Deleting a connection only removes the connection. It doesn't remove or alter the data in your sheet. You have to manually delete the rows you don't want in your sheet.

  1. Go to Connections Edit Connection
  2. In the Table Connection Summary screen, select Delete Connection.

Enable or pause a connection

You might pause a connection to put a project on hold, perform troubleshooting, keep the data in the sheet for a specific time, or connect to a different DataTable.

  1. Go to Connections Edit Connection
  2. In the Table Connection Summary screen, select Delete Connection.
  3. Toggle of Connection enabled

Share a DataTable

You must be an admin on DataTable to share.

  1. Go to Browse > DataTables.
  2. Hover over the row you want to work with, and then select the sharing icon. 
  3. In the Share DataTable with others box, enter the name of the user you want to share the DataTable with. 
  4. In the permissions box, select Viewer or Admin. You can change this setting at any time. 
  5. Select Done to save your changes. 

You can access sharing from the top right corner in DataTable.

  • To delete someone from a DataTable, hover over their name and select delete [x] on the right side of the row.

To transfer the DataTable, follow the instructions above to add a new admin, then delete the former admin.

Was this article helpful?
YesNo