Time zone setting for enterprise account
I'm getting really frustrated with how SmartSheet is handling the dates. Everything seems to be the American format by default for any form of notification or automation regardless of your personal or column settings. Why can't the default format be changed?
Example attached. The column format for Start Date and End Date is set-up as DD-MMM-YYYY and my personal setting is Europe, yet the notification is displaying MM-DD-YY
It is the same with "Generate a document" and formulas in date column. The system overwrites the column format to be the American format rather than the format of the column in the sheet.
As we are working both in Europe and America, I've set-up every date column in the solution to DD-MMM-YYYY to avoid confusion but to no avail.
This is impacting our ability to automate reporting as at worth the date could be 12 months out on the report if people are inputting 01/12/22 (1st Dec 22 [EU] or 12th Jan 22 [US]) and the report comes at with 12/01/22 (12 Jan 22 [EU] or 1st Dec 22 [US]) or vice-versa.
Any ideas / help would be appreciated. This isn't a new challenge but I'm yet to find a suitable answer.