About DataTable

Applies to

Smartsheet Advance Package (Requires Enterprise Plan)

Capabilities

Who can use this capability

You must be an Admin or Owner of the sheet to use DataTable.

DataTable is a new type of object that can store millions of rows of data, integrate with external systems using Data Shuttle, and sync subsets of that data into sheets.

DataTable makes it possible for you to use Smartsheet features to work with large data stores or unique custom views, applied formulas, workflows, and more on that data. And your data is always consistent and up to date.

Access DataTable

To use DataTable, your Smartsheet account administrator must grant you the DataTable role in Admin Center. To create a connection between a DataTable and a sheet, you must also be an admin or owner of the sheet. 

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

Get started with DataTable

  1. Create a DataTable.
  2. Upload data to a DataTable with Data Shuttle.
  3. Connect your sheet(s) to a DataTable. Select your connection type, Add & Upload or Lookup

You’re done! You can now use data from your DataTable in sheets to analyze, perform calculations, create workflows, and more. If you want to make changes, you can manage your DataTable.