Date Format Question

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!!

Answers

  • heyjay
    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
    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
    Lea722 ✭✭✭✭

    I figured out another solution :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!