Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Date Format - Add the time eg 14/01@0930

Options
Wayne Burr
edited 12/09/19 in Archived 2016 Posts

Is there a formula available so I can create a date like the following?

 

14/01@0930

 

or is there any plans to have more date format options?

 

Such as DD/MM @ HHMM

Comments

  • Heidi Decker
    Heidi Decker ✭✭✭✭✭✭
    Options

    Hi Wayne,

    Since you don't give alot of information about how you're going to use this, I will just give you the solution that is out there and what it does.

    If you are looking to capture the date and time someone created or modified something, you can add a column that is Auto Number/System. Then select what your options is (either Modified or Created, by or date). Once you save it, it will populate the entire column with the last date and time (9/9/16  10:34am) it had been modified or created whichever you selected as your option.

    Hope this helps,

    Peace

This discussion has been closed.