Explore. Ask. Answer.

or Explore Discussions

Changing the format of a the Created (Date)

Sean CorcoranSean Corcoran ✭
in Formulas and Functions
01/18/21
Accepted

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 WatsonNeil Watson ✭✭✭✭✭
    Accepted Answer

    A few things:

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


Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Sean Corcoran

    You'll have to add a so-called helper column with the DATEONLY function.

    https://help.smartsheet.com/function/dateonly


    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    https://workbold.com/

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Sean CorcoranSean Corcoran ✭

    @Andrée Starå thanks for the reply but I have two follow up questions:

    First I can not get it to work please see screen shot below showing the formula I used and not sure it will work in my situation. If someone adds a new task at the bottom of the task list they would also need to add the DATEONLY function in the date field and that is a lot to ask end users to do. I hope the second part makes sense?


    image.png


  • Neil WatsonNeil Watson ✭✭✭✭✭
    Accepted Answer

    A few things:

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


  • Sean CorcoranSean Corcoran ✭

    @Andrée Starå Great....Thanks that works

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Sean Corcoran

    Excellent!

    You're more than welcome!

    ✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    https://workbold.com/

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Nicole PaulsenNicole Paulsen ✭

    When using Dateonly - I am noticing that anything after 6pm is coming over as the next date in the formula.

    How do I fix?

    image.png


Sign In or Register to comment.