Data Shuttle not updating with all data
I have created a Data Shuttle upload, with no filters, to replace rows on my Smartsheet destination sheet. I discovered that all rows were not being added to the destination sheet. Debugging narrowed the problem down to the contents of one column. In Smartsheet, the column is formatted as Text/Number.
In Excel for testing, I created a small test file and formatted the column as Number, as Text, and I have even added an apostrophe to the beginning. When uploaded with Data Shuttle, the highlighted row is not copied; the other rows are copied. Here is my sample Excel file:
These values will NOT be used as numbers for calculations. I thought that, at the very least, adding the apostrophe would force Smartsheet to consider it as a string. What am I missing?