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

nickjroyce
nickjroyce ✭
edited 12/09/19 in Archived 2017 Posts

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?

Tags:
· Share on FacebookShare on Twitter

Comments

  • Brent Nathan
    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.

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    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

    · Share on FacebookShare on Twitter
  • CanadaJim
    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.

    · Share on FacebookShare on Twitter
  • Paul Johnson1
    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!!!!!!

    · Share on FacebookShare on Twitter
  • ysuzuki
    ysuzuki ✭

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

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 03/12/18

    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

    · Share on FacebookShare on Twitter
  • Olli Matikainen
    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.

    · Share on FacebookShare on Twitter
  • KeRMiT VAs
    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.

    · Share on FacebookShare on Twitter
  • Kara Lumley
    Kara Lumley Employee

    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

     

    · Share on FacebookShare on Twitter
  • Matt Cole
    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 :)

    · Share on FacebookShare on Twitter
  • Kara Lumley
    Kara Lumley Employee

    Hi Matt,

    Yes, that format is included smiley

    Best,

    Kara

    · Share on FacebookShare on Twitter
  • simoncollins
    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?

    · Share on FacebookShare on Twitter
  • rybutters
    rybutters ✭

    Kara, 

    Any update on this feature's specific release timing?



    Ryan

    · Share on FacebookShare on Twitter
  • jim.wilson94326
    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.

    · Share on FacebookShare on Twitter
  • Kara Lumley
    Kara Lumley Employee

    Hi Jim,

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

    Best,

    Kara

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories