Learning Track
This Help Article appears in the Integrations and Add-ons learning track. Get the most out of this learning track by starting at the beginning.
This Help Article appears in the Integrations and Add-ons learning track. Get the most out of this learning track by starting at the beginning.
You must be an admin or owner of the sheet to access DataTable.
DataTable is a way Smartsheet can store millions of rows of data and sync subsets of that data into sheets. Once your DataTable is created and populated with data, you can connect the DataTable to a sheet (or multiple sheets) and allow cross-team collaborations using a single data source.
To use DataTable, you must:
- Be a Licensed User
- Have Owner or Admin permissions on any DataTable connected sheets
- Have DataTable permissions enabled in User Management by a Smartsheet System Admin
You can add, edit, or remove fields after you've created the DataTable. DataTable supports text, number, date, and checkbox fields. The field type is important for searching and filtering – for example, if you want to search or filter based on dates, your field will need to be the associated date type.
There are two ways to create a DataTable: Create an empty data table and populate the data later, or use a Data Shuttle workflow.
Using this method, you will create an empty DataTable and then use a Data Shuttle workflow to populate the data. Creating the DataTable first gives you more data formatting options at setup.
You can edit the DataTable schema on the Setting page at any time. Be aware changes can impact your sheet connections and Data Shuttle workflows.
The import wizard auto-detects the source file column heading and maps the headers to your DataTable schema.
This method does not support advanced date format options. The Data Shuttle workflow option will only detect the standard ISO format YYYY-MM-DD HH:MM:SSZ. If your source file contains a different format, use option one, above.
Once you have a created DataTable, you can create DataShuttle workflows to populate the DataTable with additional data.
You can create multiple workflows for a single DataTable, but use the same unique identifier to prevent the addition of duplicates and empty fields on subsequent workflow runs.