Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
Dates only display by region, would be helpful to customize display (MM/DD/YY v MM/DD/YYYY) by preference so that full date can be seen
There are actually quite a few formatting options for dates including a universally recognized YYYY-MM-DD.
how do you specify which format you want? I went through a chat with support and the only suggestions that they had were through Regional Preference in Personal Settings which does not have a DD/MM/YYYY options so I was told to post here to request this functionality be added... if it already exists that would be great!
In Grid View, you can select the date column you want to format then click on the calendar at the right of the top toolbar. You can see it in my screenshot just below the Share button. If it is not visible for you, there may be three vertical dots you can click on to show more options at which point it should appear.
Sure, but you have to set the format for each cell/column, which is often tedious. You ought to be able to choose your preference as the default in your profile.
Also, when you change it this way, it's changed for everybody, so it does nothing to solve the problem of people interpreting dates differently.
^^^ This X1000. The only region that has YYYY-MM-DD format is SA, which also comes with odd number and currency formats. Date format should not be a regional setting, as it's not really a regional thing. Or at least not exclusively. It seems to have more to do with what profession you're in: software and IT are universally in favor of YYYY-MM-DD. This was also the preference of the overwhelming majority of scientists and engineers I polled. Accounting and admin lean heavily toward DD-MM-YYYY. I'm sure there are other groups with other standards.
It's tedious to change the format manually, and it affects everybody when you do, so it doesn't actually solve anything in shared sheets. It's maddening how many deadlines have been missed over people entering dates with the "wrong" format or because they read it the wrong way. This really needs to be fixed, as it's a serious problem.
You need to be able to set date and number settings individually. YYYY-MM-DD is an iso standard. It is crazy that I can't set my date preference that way without changing my number settings or language settings. YYYY-MM-DD and #,###.## are needed.
Sign in to comment or add your vote.
