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 inconsistencies, US/UK
If you copy and paste US-format dates (mm/dd/yy) into a Smartsheet while your personal settings are English (UK) (and presumably other Anglophone options), the data will retain the US format for all dates below 13. Where the date is 13 or more, Smartsheet will automatically transpose the format to dd/mm/yy. This can be confusing.
I suggest two work-arounds.
Either:
1. Convert all the dates to the required dd/mm/yy format before you paste them into Smartsheet;
or
2. Change your personal settings to English (US), then paste in the US-format dates, save, then change your personal settings back to English (UK).
I guess the same applies (in reverse) to anybody pasting UK-format dates into their US-format Smartsheet.
Smartsheet say this is expected behaviour, so don't expect it to change any time soon.
Comments
-
Hi Andrew, thanks for posting! While speaking with our development team, they informed me this is expected behavior. We are tracking feedback for this and your input has been logged with our developers.
-
Whats odd is that on my Admin view the dates show up in US format.
On some of my users' views they have mixed US and European standards.
They have all been set to show up in US standard.
Any idea why this is happening on some of our test users accounts? Can we change them all to be US standard?
-
Jim, date format is based on each users account settings. Users can change their location and date settings by going to Account > Personal Settings > Profile > Language (Country).
This setting will affect all dates in their view - so there should not be a mix of two standards. This setting will only affect dates in Date columns, so if you have dates entered in a Text/Number column, its possible to have different formats.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives