Applies to

Smartsheet Advance Package

For more information about plan types and included capabilities, see the Smartsheet Plans page.

Capabilities

Who can use this capability

  • Editor
  • Admin
  • Owner

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Troubleshooting Data Shuttle

Learn how to troubleshoot some of the most common issues that come up while using Data Shuttle.

Who can use this?

Plans:

  • Smartsheet Advance Package

Permissions:

  • Editor
  • Admin
  • Owner

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

BehaviorResolution
I'm unable to sign into Data Shuttle
  • Sign in and out:
  • Change browsers: Smartsheet works best with the latest browsers and latest browser versions.
  • Disable browser extensions:
    • Some browser extensions interfere with Smartsheet. Check if you have any extensions enabled in Chrome by navigating to Menu > Settings > Extensions. If so, open an incognito window and try using Smartsheet. If Smartsheet works, temporarily deactivate each extension in your regular browser by turning off the toggle. 
    • Access Smartsheet again to see if the problem persists. If the issue is resolved, re-enable the extensions selectively to determine which one conflicts with Smartsheet. Keep conflicting extensions deactivated when working in Smartsheet.
  • Check your VPN: If you're using one, turn off the VPN and sign back into the Smartsheet app.
Numbers from my uploads import as a string (with leading 0s or an apostrophe)
  • Check that the column type is set to Number in the Mapping section of the workflow.
  • You can try using the VALUE function instead, like =VALUE([Current Budget]@row). This function should translate values with a leading apostrophe into being recognized as numerical
I'm having trouble mapping to a Google Sheet with tab connected to BigQueryYou need to set First Row = 2 to pull in the column names. If you set First Row = 1, it pulls in the tab name.
I'm having trouble using OneDrive/Sharepoint as the source location

You receive the following message: "need a permission to access resources in your organization that only an admin can grant. Please ask an Admin to grant permission to this app before you can use it."

This notification occurs because an MS admin locked down the ability to use your MS account for third-party authentication. A Valid Admin (usually the IT department) can give permissions to certain apps. A Microsoft admin must grant Data Shuttle permission before using OneDrive/Sharepoint as a source location.

Tips and best practices

  • With Data Shuttle, Smartsheet limitations still apply.
  • If you need to upload from a source to replace more than or merge data into 20,000 rows, you can apply filters or map to only a selection of columns. You can also create multiple workflows using a standard data category to distribute the data into multiple sheets. You can offload up to 20,000 rows. 
  • If you typically work with large datasets that exceed the sheet limitation of 20,000 rows, consider uploading to a DataTable.
  • Adding, renaming, or removing columns might affect dependent automations. If an error triggers because of column renaming, revert to the original name or update the automation to refer to the new name.
  • Manually delete attachments and their versions from sheets that use multiple workflows or those that are frequently accessed. There’s currently no automatic way to replace or delete versions, so regular auditing is necessary to avoid issues related to excessive attachments

Related Content

Was this article helpful?
YesNo