Applies to

Smartsheet Advance Package

Capabilities

Who can use this capability

You must be anAdminor老板of the sheet to use DataTable.

Manage existing DataTables

PLANS

  • Smartsheet Advance Package

Permissions

You must be anAdminor老板of the sheet to use DataTable.

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.

数据表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
  • CreateData 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连接menu, and then selectEdit Connection.
  2. From theTable Connection Summaryscreen, clickDelete Connection.

Enable or pause a connection

You might pause a connection to puta project on hold, perform troubleshooting,保持中的数据sheet for a specific time, or connect a different DataTable.

  1. Go to the连接menu, and then selectEdit Connection.
  2. From theTable Connection Summaryscreen, clickDelete Connection.
  3. Set theConnection enabledtoggle to off.

Share a DataTable

You must be an admin on DataTable to share.

  1. On the right sidebar, selectBrowse>数据表s.
  2. Hover over the row you want to work with and then select the sharing icon.
  3. In theShare DataTable with othersbox, enter the name of the user you want to share the DataTable with.
  4. In the permissions box, selectViewerorAdmin. You can change this setting at any time.
  5. SelectDoneto 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.
Was this article helpful?
Yes No