Set up DataTable

APPLIES TO

  • Smartsheet Advance Package

For more information about plan types and included capabilities, see the Smartsheet Plans page.

RELATED CAPABILITIES

Who can use this capability?

  • Owner
  • Admin

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

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

Get started with DataTable

APPLIES TO

  • Smartsheet Advance Package

For more information about plan types and included capabilities, see the Smartsheet Plans page.

RELATED CAPABILITIES

Who can use this capability?

  • Owner
  • Admin

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

DataTable by Smartsheet allows 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.

DataTable is available as a premium offering. For pricing information, contact our sales team.

Log in to DataTable

Prerequisites

To use DataTable, you must:

  • Have Owner or Admin permissions on any DataTable connected sheets
  • Have DataTable permissions enabled in Admin Center by a Smartsheet System Admin
  • DataTable must be a premium application available on the plan.

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.

Access DataTable

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

Get started with DataTable

You can build a DataTable from scratch, but the easiest way to create one is to upload the data via Data Shuttle.

  1. Create a DataTable.

  2. Connect a Data Shuttle workflow to DataTable to import more data into the DataTable.

  3. Set up connections to bring records from DataTable into a sheet. 

  4. Manage your DataTable. 

Tips and best practices

Keep these tips in mind as you work with DataTable:

  • Your dataset can contain no more than 2 million rows and 200 fields/columns.
  • If you perform lookups and updates to your data or merge in new rows, your data must contain a column with a unique identifier for each data point. 
  • The unique identifier keeps your data consistent. 
  • When creating multiple workflows into a DataTable, use the same field in each workflow for your unique identifier to prevent empty fields or duplicate rows.
  • You can connect up to 1,000 sheets to your DataTable.
  • When populating a sheet from a DataTable via Connections, sheet limitations still apply.
    In any case Smartsheet limitations still apply via Data Shuttle and DataTable.
  • Data should flow from your source into DataTable.You can’t use DataTable to sync data back from your sheet. If necessary, use Data Shuttle to offload sheet changes back to your source. 
  • The connection ID is a helpful piece of information if you need support. To find the ID, go to the Connection Summary screen and select the arrow icon between the DataTable and sheet names.
  • Data Shuttle workflows into a DataTable have different options than those directly into a sheet. Data Shuttle workflows:
    • Can’t schedule workflows to run on attachment to a sheet
    • Can’t add advanced date format options
    • Can’t replace all data with a new import file
    • Can’t delete rows that don’t match filter criteria