Email alert with Date format

Sandhiya07

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

Paul McGuinness

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

Paul Newcome

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.

Sandhiya07

Hi @Paul Newcome ,

Could you please elaborate it, sorry I didn't get it.

Helper column means how?

Thanks,

Sandhiya P

Paul McGuinness

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

Luis Martinez Ruiz

Paul McGuinness

Aug 23, 2022

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.

https://us.v-cdn.net/6031209/uploads/3Y75HFQ52M4Y/image.png

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

It is a shame that Smartsheet does not improve the product beyond the existing functionality. Regarding your suggestion, perhaps you could have a "helper sheet" with the month numbers and their names to simplify this formula. You could add columns with 3-letter month names and even in another language.