Manage existing DataTables

If you're an admin on DataTable, you can share a DataTable with others in your organization, granting either admin or viewer access. If you created the DataTable, you are already an admin; you can create additional admins or viewers.

Log in to DataTable

You can manage all your DataTables to perform actions, such as the following:

• View all of your DataTables and DataTables you’ve been shared to
• Share your DataTables
• View, edit, and delete all sheet connections
• View and filter the data in a DataTable
• Add, edit, and delete fields in a DataTable

Select the DataTable you want to work with to make changes.

DataTable permission levels

If you're an admin on DataTable, you can share a DataTable with others in your organization, granting either admin or viewer access. If you created the DataTable, you are already an admin; you can create additional admins or viewers.

Admins can:

• View, edit, and delete a DataTable
• View, edit, create, and delete records on a DataTable
• Modify permissions on a DataTable
• Manage DataTable connections 
• Create Data Shuttle workflows.

Viewers can:

• View the DataTable
• View records in the DataTable
• Manage DataTable connections

Smartsheet System Admins can add and remove Admins and Viewers for all DataTables in an organization. To view all DataTables, the System Admin can toggle View all in the DataTable list view. A System Admin can share a DataTable with any other licensed user on the plan, preventing DataTables from being left without an owner.

Manage DataTable connections

There are two ways to access existing connections:

• In the sheet, go to the Connections menu and select your DataTable.

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

Delete a connection

Deleting a connection will only remove the connection. It will not remove or alter the data in your sheet. You will need to manually delete the rows you do not want in your sheet.

1. Go to the Connections menu, and then select Edit Connection. 
2. From the Table Connection Summary screen, click Delete Connection.

Enable or pause a connection

You might pause a connection to put a project on hold, perform troubleshooting, keep the data in the sheet for a specific time, or connect a different DataTable.

1. Go to the Connections menu, and then select Edit Connection. 
2. From the Table Connection Summary screen, click Delete Connection.
3. Set the Connection enabled toggle to off. 

Share a DataTable

You must be an admin on DataTable to share.

1. On the right sidebar, select Browse > DataTables.
2. Hover over the row you want to work with and then select the sharing icon. 
3. In the Share DataTable with others box, enter the name of the user you want to share the DataTable with. 
4. In the permissions box, select Viewer or Admin. You can change this setting at any time. 
5. Select Done to save your changes. 

You can access sharing from the top right corner in DataTable.

• To delete someone from a DataTable, hover over their name and select delete [x] on the right side of the row.

Transfer a DataTable

• Follow the instructions above to add a new admin, then delete the former admin.