Apply date formats to a column

Apply date formats to a column

Shaine GreenwoodShaine Greenwood Employee
edited 06/21/19 in Announcements

Hello Community,

Teams that span multiple regions often encounter issues with date formatting. For example, while 05/03 is May 3rd in the US, it might stand for March 5th in other locales. As one of our top requested features, additional date formats for date columns is critical for the many teams that work with stakeholders across multiple locations, and it is now available to use.

You will now be able to:

  • Adjust dates to your desired format at the cell or column level
  • Update date formatting in grid view and Gantt view
  • Display dates with the new formatting on reports and dashboards

To learn more about this release, see our help article. Then select the date format that works best for you!

Comments

  • The help article every plan but Teams that has access to this feature.  I am assuming that is an oversight.

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

    Hi Shaine,

    Thanks!

    That's excellent news!

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Bill, 

    Thanks for pointing this out. Date formats are available to all Smartsheet plans, and we are updating the help article.

    Best,

    Kara

  • Hi Bill,

    Good catch—sorry about that! I've edited the article to say "All Smartsheet Accounts." You should be able to apply date formats on a Team account.

    Due to caching, there may be a delay for you to see the wording change in the help article.

  • This is welcomed Shaine - Any updates on native time functions though?! 

    Sean

  • I see that the regional function was updated, but what about an option to use a standard shorthand version of a date in the US, M/DD?

  • No updates on that one, Sean.

    Please fill out a product enhancement request (even if you have already) so our Product team gets a sense of the demand. You can submit your enhancement request using the form under Quick links on the right of the community site.

Sign In or Register to comment.