Create a DataTable

Applies to

Smartsheet
  • Enterprise
Smartsheet Advance Package (Requires Enterprise Plan)

Capabilities

Who can use this capability

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 use Smartsheet capabilities to work with your data. 

Get started

  1. On the left panel, click  Browse> DataTables and then click Create.
  2. Enter a name for your DataTable and then select Next

Add fields 

You can add fields to your DataTable. DataTable supports text, number, date, and checkbox fields. Fields in DataTable work very much like columns in a sheet. You can enter whatever type of data you want but the type will determine how you can search across the data. For example, if you want to search based on dates, your field will need to be of type date.

  1. Fill out the Create fields for your table form and then click Next. Enter a name for the field on the left and select the field type on the right. 
  2. Select Next and review the fields. Select Back to make changes or Create to build the DataTable.