Email alert with Date format

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

· Share on FacebookShare on Twitter

Best Answer

  • Paul McGuinness
    Paul McGuinness Overachievers
    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.

    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

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!