Changing the format of a the Created (Date)

Options

I wanted to have a date when a task was added so I am using the Create (Date) under system-generated column. "See Below" but I only want to display the date not the time. I was looking away to format the cell so it would show only the date like my other date columns and I can't find anything. Any help would be great



image.png


Best Answer

  • Neil Watson
    Neil Watson Community Champion
    Answer ✓

    A few things:

    • your "column27" must be a date type
    • The formula is "=DATEONLY(Created@row)
    • Once done, convert to a column formula and any new rows will automatically fill with formula
    image.png image.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!