Standardising imported date formats
I hope you are all well, and someone may be able to assist:
On a sheet I am working on, a 3rd party app runs an automation that imports a date into a specified column in smartsheet.
The date when imported arrives in the following format: "2023-01-04 12:26:14".
There is no way to change the format which this date is imported in.
I would like this to display in a standard format, excluding the time, i.e "04/01/2023".
If I change the date format for the column to "Regional (Default Format)" then the date changes to the correct format, but only if I double click on the cell and then click out of it.
I am happy to use a helper column if required.
Any advice would be welcomed!
Thank you, Glen.
Help Article Resources
Check out the Formula Handbook template!