Data Uploader - full text not loaded/unique identifier column
Hi team, can you please advise the best way how to handle below cases?
1) Smartsheet is not capturing the full text via Data uploader, it is in a format of: 28/01/2021 02:01:52 and it takes only 28/01/2021. The source sheet is stored on google drive. I know Smartsheet is not supporting time formats, but the column is set to "text" so I expected this would capture the full text. I'd like to use this as "unique identifier column" for "merge" option which is not working now.
2) Is there any way how to use formula for "unique identifier column" of "merge" option? Eg I'd like to use combination of two columns for that but I don't see any way to have this compared via data uploader. I cannot add the same into the data source, it can only be done in smartsheet, thus searching for any option how to have this covered by data uploader as well - to run concatenate in the background of data uploader to identify rows which to be uploaded into smartsheet.