How do I change the date format if my column type is Created Date?

Options

Hello,

How do I change the format if my column type is Created Date? Currently it is also showing the time, but I would like for only the date to show if possible. Thank you in advance.

Best Answer

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    edited 07/10/24 Answer ✓
    Options

    Make a new Date column in your Sheet and add formula =DATEONLY([Created Date]@row) as a column formula.

    You can then freely apply the formatting of your choice.

    School of Sheets (Smartsheet Partner)

    If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

Answers