Changing the format of a the Created (Date)

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




Best Answer

  • Neil Watson
    Neil Watson ✭✭✭✭✭✭
    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


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!