Date Format Question

Lea722

Hello Smartsheet Community,

How can I get the Date Helper column below to automatically show the date format as D-M-YYYY? There is a formula in that column and it's a date column. When I click on the date format button and select another format type, it does not do anything. The D-M-YYYY format seems to be the only one that works with the month formula.

Below is what I'd like it to look like. I did this manually and would need it to be automatic.

Thank you!!

heyjay

=LEFT([Date Column]@row, FIND(" ", [Date Column]@row, LEN(LEFT([Date Column]@row, FIND(" ", [Date Column]@row) - 1))))

Looks like your initial formula is including a space at the end. I used len to subtract 1 from the result.

Lea722

Thank you for your response! How can I get the date format to show as D-M-YYYY even though there is a formula in the column? I have the formula applied to the whole column. I can't get mine to show like yours with the formula you shared.

I appreciate you taking the time to help!

Lea722

I figured out another solution :)