Time format data change after uploading data to smartsheet from excel via Data Shuttle.

Pradip Chavda

I am using data shuttle to upload data from local .xlsx file.

Below is the data available in .xlsx file in "hh:mm" format.

After uploading data to smartsheet by data shuttle, The value is changed and showing in below format.

.xlsx file is generating from system automatically so i can not change or add any filled in .xlsx file.

So, without doing any change in .xlsx file how can i populate same type of data in smartsheet.

Thank you in advance for your valuable time.

Regards,

Pradip Chavda

Paul Newcome

Double check the column type in your Smartsheet is set as a text/number type column and not a date type column.

Pradip Chavda

Hello Paul,

Thank you for your response. I checked column type. It is text/number.

I changed column type from Auto to number in data shuttle workflow during in mapping.

Now result is coming as below. I tried to change to text but the result is same as earlier.

It will be better if you can help me out.

Thank you Paul for your time.

Regards,

Pradip

Danielle Wilson

@Pradip Chavda Since Smartsheet isn't really set up to take in times (unless you're using the TIME() function), I would recommend importing your times as "Text", which should solve your issue.

StacieSmartMeet

Are there any additional options for formatting? I have the same issue, but when trying to change the excel file to text, it changes the time to a number format like this: 0.689583333.