Importing Dates with Data Uploader
The source data that I download to an excel file from the external system is in this format " 11/2/2020 10:59 AM". Smartsheet does not recognize this as a date when imported into a date cell. I am using the dates to chart year over year data. The only way I've been able to get it to work is to change the column to a text column, save, then turn it into a date column. Then it changes to the 11/2/2020 format. This defeats the purpose of having the data automatically upload using the data uploader. I still have to manipulate the data.
Does anyone know how to solve this problem? Any help would be greatly appreciated.