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

To use DataTable:

  • You must have Owner or Admin permissions on any sheets where a DataTable Connection will be built.
  • DataTable must be a premium application available on the plan.
  • You must have DataTable Premium Application permissions enabled in User Management by your Smartsheet System Admin.

To check your access level, log in to DataTable.

Visit the DataTable Marketplace page to learn how to contact your Sales representative for pricing-related inquiries

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

Troubleshooting DataTable

This guide helps you if you have issues navigating DataTable. 

PLANS

  • Smartsheet Advance Package

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

Permissions

To use DataTable:

  • You must have Owner or Admin permissions on any sheets where a DataTable Connection will be built.
  • DataTable must be a premium application available on the plan.
  • You must have DataTable Premium Application permissions enabled in User Management by your Smartsheet System Admin.

To check your access level, log in to DataTable.

Visit the DataTable Marketplace page to learn how to contact your Sales representative for pricing-related inquiries

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

Special characters alongside numbers in a source dataset (currency symbols, commas, percent signs, etc.) do not interpret as numeric values when you import into DataTable number fields.

Cause

Smartsheet will write any values in the underlying data set that contain alpha or special characters as text strings in DataTable Number fields. Smartsheet brings it into the sheet via connections as strings. The one exception to this rule is scientific numbers which interpret as valid numbers. If the number exceeds the bounds limited to, Smartsheet writes to a sheet as a string.

Troubleshooting Steps/Resolution

Make sure that the underlying dataset stores numeric values as numbers with a single decimal point only since Smartsheet parses user input with the default (US-centric) number format.

If you want your data to land on sheets as numbers:

  • When loading percentages from an underlying dataset, format percentages as a decimal without a % symbol (i.e. 0.5 instead of 50%).
  • When loading dollar values from an underlying data set, format monetary values as a decimal without commas or currency symbols (I.e. 15000.00 instead of $15,000.00 or 15,000.00)

If you want to load data into DataTable to land on sheets as numbers, you must: 

  1. Set the DataTable field type to Number.
  2. Send data into the DataTable with the following restrictions:
    • Remove commas for numeric values (e.g. 1000 instead of 1,000)
    • Convert percents to decimal format (e.g. .99 instead of 99%)
    • Remove currency symbols (e.g. 123.45 instead of $123.45).
Was this article helpful?
YesNo