Date Format

nickjroyce

Hello,

 

When I set the column type as "Date", I need to be able to choose different formats. For example, it currently defaults to MM/DD/YYYY, but I need the column to default to MM/YY or MM/YYYY. This data will then be pulled to another application (Domo), but it needs the correct format when being transferred over. How can we make this happen? Is this not a function in Smartsheet already?

Brent Nathan

The date settings are based on your language selection in your account profile settings. Its a very unusual place to change a date format, but that is the answer. Check through the various english options and it will preview the date formats.

J. Craig Williams

You could also create another column to convert the date format to a different format, though the content will then be in text.

If the other application will be ok with that, then that is what I would do.

Craig

CanadaJim

Hi Nick.

I too have requested this. So have others for the past 18 months.

Please open a request with support to add custom date formats per user, independent of language settings.  There should be a link on the right under "Quick Links" titled "Submit Product Enhancement Request".  The more of us who want it enough to request it, the faster it'll get done.

Paul Johnson1

Please Please add a formatting rule for date to change to text format. It is very confusing trying to interpret dates in EU dd/mm/yr and US mm/dd/yr. Text is much better 1st Jan 2017.

This is an industry standard now in most packages. 

Using contrived formulae is not an option to convert sorry!!!!!!

ysuzuki

Hello Craig, if you have, could you please provide an example? 

J. Craig Williams

This converts the [Start] date to ISO-8601

=YEAR(Start@row) + "-" + IF(MONTH(Start@row) < 10, "0") + MONTH(Start@row) + "-" + IF(DAY(Start@row) < 10, "0") + DAY(Start@row)

again, this is in a Text/Number type column.

Craig

Olli Matikainen

Adding my vote to include a choice for date format... difficult to 'read' the current dd/mm/yy format. Would like to have choice of yyyy-mm-dd, dd-mmm-yyyy, mm-dd-yyy, etc.

KeRMiT VAs

As everyone above has said, we need the ability to format the date column for how we need it to read. So for example, I need the date column to be in format m/d so if January 3 it'd show as 1/3. In Excel, Google Sheets or any other spreadsheet type program you always have the ability to format the column to how you need it to be. Why this isn't already a standard for a program called "Smartsheet", it's not smart to not allow your user to be able to format their column how they need it to be. I've just signed up for a 30-day trial and I'm not impressed with the inability to format things how I'd like them to be.

Kara Lumley

Hi all,

Thank you for your patience. 

Barring any major issues, we will be releasing the ability to format date columns with 10 new non-ambiguous formats in June.

Best,

Kara

 

Matt Cole

Hi Kara, we are working internationally and I was wondering if the update in June includes DD-MMM-YYYY format i.e. 01-JAN-2020. This will help us avoid confusion where some teams are working in DD-MM-YY and others in MM-DD-YY format. Thanks

Kara Lumley

Hi Matt,

Yes, that format is included 

Best,

Kara

simoncollins

I'm trying to plan by the hour and would therefore really like to see the date and time. Is there anyway to do this?

rybutters

Kara, 

Any update on this feature's specific release timing?

Ryan

jim.wilson94326

Has this feature been released? Like others have mentioned, this is critical for my organization, which is global. I was just in a meeting reviewing a project schedule with colleagues from Europe and LATAM and actually apologized to them for the U.S.-specific date format. I need to be able to specify an ISO 8601 YYYY-MM-DD date representation to be enforced on all views as soon as possible. Thanks.

Kara Lumley

Hi Jim,

Yes, it has. More information can be found here.

Best,

Kara