Changing the format of a the Created (Date)

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




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


Answers

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

    Hi @Sean Corcoran

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


    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

    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.

  • @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?



  • 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


  • @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

    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.

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

    How do I fix?


Sign In or Register to comment.