Email alert with Date format

Options
Sandhiya07
Sandhiya07 ✭✭
edited 08/22/22 in Formulas and Functions

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

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓
    Options

    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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    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
    Options

    Hi @Paul Newcome ,

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

    Helper column means how?

    Thanks,

    Sandhiya P

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!