Applies to
Capabilities
Who can use this capability
- Admin
- Viewer
Troubleshooting DataTable
This guide helps you if you have issues navigating DataTable.
Who can use this?
Plans:
- Smartsheet Advance Package
Permissions:
- Admin
- Viewer
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
What happens if my sheet fills up?
Your sheet can fill up when the filter criteria for your DataTable connection match too many records or add more data to your sheet.
- If your sheet reaches the (legacy) capacity limit of 500,000 cells, the connection stops syncing data.
- If syncing fails, update the filter criteria for your connection to be more specific and remove rows from your sheet.
Once you have created room in your sheet, the connection automatically resumes.
For a lookup mode connection, what happens if there are multiple rows in my sheet with the same unique identifier?
Each row in the sheet has the corresponding values mapped in based on how you configure the connection
For a lookup mode connection, what happens if there are multiple records in my DataTable with the same unique identifier?
The connection uses the record it finds first.
For a lookup mode connection, what happens if I change the unique identifier in my sheet?
The DataTable overwrites existing data in the sheet cells that map to the DataTable.
How do I create a date field in my DataTable?
The date format tells the DataTable how to parse the data in your CSV or Excel file.
When initially creating a DataTable from a Data Shuttle workflow, the date format expects the source file to be in ISO format e.g. 2020-09-17.
If creating the DataTable from scratch, there is an option to specify the date format after selecting the date type. This format must match the date in your source file.
If you are having problems filtering against your date format, you may need to modify the date format. This can be done when the DataTable is created and populated via the settings tab in the DataTable dashboard.
When you create a new DataTable, add a field, select Date as the type, and specify the date format.
How do I filter based on a date field in my DataTable?
When you create a new connection, select the field type Date and then choose the date with the date picker, using the format mm/dd/yy. For example, to filter records after July 9, 2021, you would enter 07/09/21. For date comparisons, you can use operators like is less than, is greater than, is between, is equal to, and is not equal to.
The In the Next/Last N days filter option excludes the current day. To address this, use the filter option from today/tomorrow/yesterday. This allows you to include today's date in the relative date filter criteria if desired.
Sometimes my numbers import as strings, not numeric values. Why is that?
DataTable doesn’t interpret special characters like currency symbols or commas as defining numeric values. DataTable only sees those characters as part of a text string. Use decimal places to indicate currency amounts or percentages instead.
- To format percentages in your data set, use a decimal without a % symbol. For example, 0.5 instead of 50%
- To format monetary values, use a decimal only. Don’t use a comma or any currency symbols. For example, 15000.00 instead of $15,000.00 or 15,000.00
To have your data appear on sheets as numbers
- Set the DataTable field type to Number.
- Send data into the DataTable with the following restrictions:
- Strip out commas for numeric values. For example, change 1,000 to 1000
- Convert percents to decimal format. For example, change 99% to 0.99 or 78.23% to .7823
- Strip out currency symbols. For example, change $123.45 to 123.45