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
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?
Comments
-
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.
-
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
-
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.
-
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!!!!!!
-
Hello Craig, if you have, could you please provide an example?
-
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
-
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.
-
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.
-
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
-
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
-
Hi Matt,
Yes, that format is included
Best,
Kara
-
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?
-
Kara,
Any update on this feature's specific release timing?
Ryan -
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.
-
