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.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!