Date format in automated emails
Hi there,
I've set up multiple automated emails as part of the workflow process, and have just noticed that the dates contained in the automated emails are in the incorrect format, despite me setting my regional preference in the settings.
I have the dates set up in my settings for the United Kingdom format (i.e. DD/MM/YY) and this is how it shows in the Smartsheet itself. However, I have chosen for the date columns to appear in the automated email (under the personalised message where you can choose which columns to show) and these show up as MM/DD/YY.
I've looked and can't see any way to amend this, which seems odd. Could someone advise if I'm doing something wrong, and if not, could I ask that this is something that can be looked at?
Thanks
Colin
Comments
-
Hi Colin,
Have you changed the settings for the date column(s) as well?
More info: https://help.smartsheet.com/articles/2479481-apply-standardized-date-formats-in-your-sheet
Did that work?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
The date columns all use the regional default format, so are all set up correctly. They show correctly on the sheet, the settings seem to be set up correctly - it's just on the automated emails that still shows the wrong format.
Any guidance/advice you can offer will be gratefully received.
Many thanks
Colin
-
Happy to help!
Have you also checked your personal settings?
Was it correct?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Colin_G, did you get a resolution for this issue? I am having the exact same issue here in Australia.
-
Hi Alicia, forgive me - a lot has happened inbetween me posting the question and now, so I don't quite recall! I don't believe I did get a resolution or managed to make it work (I'm pretty certain that I was doing everything correctly), and have just checked some of the processes/workflows we've used in the past few years and can't see any references to dates, so it's possible we just went about things a different way and removed dates altogether from the emails. I would hope there was some progress in this in the last few years but it sounds like that isn't the case. Apologies I can't give you better news!
-
Hello,
Is there a solution for this by now?
We are encountering the same problem.
Personal settings the of the people are correct. it's only the email where it's wrong.
thanks!