Force long date in workflow email

Options

Hi,

I have a date in a workflow email --  {{DATE}} that show up as "10/7/2023"

Any way to have it be:

Thank you!!

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 01/16/23
    Options

    Hi @Joseph Farahat

    I hope you're well and safe!

    Try something like this.

    =IFERROR( IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday"))))))) + ", " + IF(MONTH(Date@row) = 1, "January", IF(MONTH(Date@row) = 2, "February", IF(MONTH(Date@row) = 3, "March", IF(MONTH(Date@row) = 4, "April", IF(MONTH(Date@row) = 5, "May", IF(MONTH(Date@row) = 6, "June", IF(MONTH(Date@row) = 7, "July", IF(MONTH(Date@row) = 8, "August", IF(MONTH(Date@row) = 9, "September", IF(MONTH(Date@row) = 10, "October", IF(MONTH(Date@row) = 11, "November", IF(MONTH(Date@row) = 12, "December")))))))))))) + " " + DAY(Date@row) + ", " + YEAR(Date@row),""

    Did that work/help?

    I hope that helps!

    Have a fantastic week & Happy New Year!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    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.

  • Joseph Farahat
    Options

    Hi Andree,

    All I can is WOW!!! Thank you..so much work.

    Am i supposed to place this in the work flow email part??

    I tried this & did not work.

    {{DATE=IFERROR( IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday"))))))) + ", " + IF(MONTH(Date@row) = 1, "January", IF(MONTH(Date@row) = 2, "February", IF(MONTH(Date@row) = 3, "March", IF(MONTH(Date@row) = 4, "April", IF(MONTH(Date@row) = 5, "May", IF(MONTH(Date@row) = 6, "June", IF(MONTH(Date@row) = 7, "July", IF(MONTH(Date@row) = 8, "August", IF(MONTH(Date@row) = 9, "September", IF(MONTH(Date@row) = 10, "October", IF(MONTH(Date@row) = 11, "November", IF(MONTH(Date@row) = 12, "December")))))))))))) + " " + DAY(Date@row) + ", " + YEAR(Date@row),""}}

    tried this & did not work.

    {{DATE}}=IFERROR( IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday"))))))) + ", " + IF(MONTH(Date@row) = 1, "January", IF(MONTH(Date@row) = 2, "February", IF(MONTH(Date@row) = 3, "March", IF(MONTH(Date@row) = 4, "April", IF(MONTH(Date@row) = 5, "May", IF(MONTH(Date@row) = 6, "June", IF(MONTH(Date@row) = 7, "July", IF(MONTH(Date@row) = 8, "August", IF(MONTH(Date@row) = 9, "September", IF(MONTH(Date@row) = 10, "October", IF(MONTH(Date@row) = 11, "November", IF(MONTH(Date@row) = 12, "December")))))))))))) + " " + DAY(Date@row) + ", " + YEAR(Date@row),""


    ********************************************

    This is the whole text in the flow...

    Hi {{STAFF NAME}}

    IMPORTANT: **Your timing may change as the client makes final decisions.

    NOTE: {{Comments to staff SA}}

    EVENT NAME: {{EVENT Name (PM)}}

    DATE: {{DATE}}

    CALL TIME: {{ST Planned START Time SA}}

    END TIME: {{Planned END Time SA}}

    ATTIRE: {{DRESS CODE SA}}

    ARRIVE: {{Arrive SA}}

    -- LOCATION: -- 

    {{ADDRESS SA}}

    {{Address more notes SA}}

    To answer click the blue button "Open Update Form"


    Note: To review all your scheduled dates, use your personal schedule link.

    Don’t have one? Contact me.


    Click blue button Here .....

    ************************************************


    If too much trouble no worries.. we move on

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    @Joseph Farahat

    You're more than welcome!

    Yes, you'd need to add a so-called helper column, add the formula, and replace the reference in the Alert with the new one.

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    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.

  • Joseph Farahat
    Options

    Hi Andree,

    Thank you for taking the time to offer your suggestions. At this point I'm going to move on because its beyond my skill level.

     Our business is so crazy complex that we are trying to find the easiest solution to everything. I cheated by adding a column called day next to the date column. So it takes an extra 10 seconds for the person that inputs to select the day that matches the date.

     Not an elegant solution but a Band-Aid.

    Thanks!!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    @Joseph Farahat

    Happy to help!

    I can take a look at it while working on the other project.

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    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.