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.
1. Convert all the dates to the required dd/mm/yy format before you paste them into Smartsheet;
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.