Text to Date
Is there an easy way to change a date that was entered into a text field and copy it as a date into a date field? I have a file that was downloaded from one system as an XLS with date and time but as a text field. I want to create a date column and somehow remove the date from the original column and put it into the date column. When I do this Smartsheet is not recognizing that the new date in the date column as an actual date. Wouldn't matter so much but I need to do a function on that column and it doesn't work since it's not seeing the new dates in the date column as actual dates.