Email alert with Date format

Hi Team,
I can bring date format of this type "July 12, 2022" in Sheet. But when I sent an alert mail, it is coming with default format "07/12/22".
Please suggest me solution for this ASAP.
Thanks,
Sandhiya P
Best Answer
-
Hi @Sandhiya07
You need to add a new column in your sheet that can hold the date in the format you want to include in your email, you can then use that formatted date as a field or direct text in your email notification.
Something like the below should work.
The formula that converts the date is:
=IF(MONTH([Actual date]@row) = 1, "January", IF(MONTH([Actual date]@row) = 2, "February", IF(MONTH([Actual date]@row) = 3, "March", IF(MONTH([Actual date]@row) = 4, "April", IF(MONTH([Actual date]@row) = 5, "May", IF(MONTH([Actual date]@row) = 6, "June", IF(MONTH([Actual date]@row) = 7, "July", IF(MONTH([Actual date]@row) = 8, "August", IF(MONTH([Actual date]@row) = 9, "September", IF(MONTH([Actual date]@row) = 10, "October", IF(MONTH([Actual date]@row) = 11, "November", IF(MONTH([Actual date]@row) = 12, "December", "Month Error")))))))))))) + " " + DAY([Actual date]@row) + ", " + YEAR([Actual date]@row)
If you require help on setting up text fields in notifications and using the formatted date this article should help - https://help.smartsheet.com/articles/2479256-customize-the-content-of-your-alerts-and-requests
Hope that helps
Thanks
Paul
Answers
-
The alert is pulling the back-end data as opposed to the display data.
You will need to insert a helper column that will convert your date format into a text string and then include this column in your alert.
-
Hi @Paul Newcome ,
Could you please elaborate it, sorry I didn't get it.
Helper column means how?
Thanks,
Sandhiya P
-
Hi @Sandhiya07
You need to add a new column in your sheet that can hold the date in the format you want to include in your email, you can then use that formatted date as a field or direct text in your email notification.
Something like the below should work.
The formula that converts the date is:
=IF(MONTH([Actual date]@row) = 1, "January", IF(MONTH([Actual date]@row) = 2, "February", IF(MONTH([Actual date]@row) = 3, "March", IF(MONTH([Actual date]@row) = 4, "April", IF(MONTH([Actual date]@row) = 5, "May", IF(MONTH([Actual date]@row) = 6, "June", IF(MONTH([Actual date]@row) = 7, "July", IF(MONTH([Actual date]@row) = 8, "August", IF(MONTH([Actual date]@row) = 9, "September", IF(MONTH([Actual date]@row) = 10, "October", IF(MONTH([Actual date]@row) = 11, "November", IF(MONTH([Actual date]@row) = 12, "December", "Month Error")))))))))))) + " " + DAY([Actual date]@row) + ", " + YEAR([Actual date]@row)
If you require help on setting up text fields in notifications and using the formatted date this article should help - https://help.smartsheet.com/articles/2479256-customize-the-content-of-your-alerts-and-requests
Hope that helps
Thanks
Paul
Help Article Resources
Categories
Check out the Formula Handbook template!