Maintain your program

Deleting data from a DataTable

Manually delete rows from your DataTable as needed. Currently, no API supports row deletion from DataTable, so you must remove unwanted data directly. 

Delete or pause a connection

Manage your DataTable connections proactively to align with project needs or resolve issues. 

Action

When to use

Delete a connection

  • Prevent any further updates to the connected sheet(s).
  • Keep the existing data in the sheet intact, without deletion or alteration. Removing a connection eliminates the sync relationship, but doesn’t affect any data that is already present in your sheet.
Pause a connection
  • Put a project on hold.
  • Troubleshoot sync behavior without deleting the setup.
  • Preserve current data in the sheet for a specific period.
  • Connect the sheet to a different DataTable temporarily.

Transferring ownership

Transfer DataTable ownership when team responsibilities change or when someone leaves the organization.

Transfer ownership within the same organization

  • The current DataTable Admin can reassign ownership to another user within the same organization.
  • A System Admin can manage and transfer ownership through the list of DataTables accessible via the Profile icon menu.

Transfer ownership across organizations

  • You must contact Smartsheet Support to request the change since cross-org transfers require additional validation.