Applies to
Capabilities
Who can use this capability
You must be anAdminor老板of the sheet to use DataTable.
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.
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.
- Go to the连接menu, and then selectEdit Connection.
- 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.
- Go to the连接menu, and then selectEdit Connection.
- From theTable Connection Summaryscreen, clickDelete Connection.
- Set theConnection enabledtoggle to off.
Share a DataTable
You must be an admin on DataTable to share.
- On the right sidebar, selectBrowse>数据表s.
- Hover over the row you want to work with and then select the sharing icon.
- In theShare DataTable with othersbox, enter the name of the user you want to share the DataTable with.
- In the permissions box, selectViewerorAdmin. You can change this setting at any time.
- 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.