This Help Article Appears in the Following Learning Tracks
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.
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
- Create a DataTable.
- Upload data to a DataTable with Data Shuttle.
- 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.