Data Shuttle Changing 100% to 1%
When using Data Shuttle to import data from an .xlsx sheet, the decimals from that sheet that equal 100% are instead converted to 1% in Smartsheet.
This issue is the same as in this Community post that has no answer or resolution: https://community.smartsheet.com/discussion/90205/data-shuttle-changing-my-100-to-1
The format of the field in the .xlsx (or .csv) doesn't seem to matter. We've tried them all. We are having 2 decimal points included, so the final number in Smartsheet should be 100.00% (or 97.65% or whatever). Percentages less than 100.00% are transferring correctly.