Reply To: Pulling the date into a text column

Inner Circle › Ask Smartsheet Guru Crew Anything › Pulling the date into a text column › Reply To: Pulling the date into a text column

March 4, 2025 at 12:05 pm #596
Peggy Parchert
Participant

    I got this to work but I need the month and day to always be 2 digits. How do I ensure that?

    Working formula:

    =IFERROR(“” + YEAR([Release Event Start Date]@row) + MONTH([Release Event Start Date]@row) + DAY([Release Event Start Date]@row), “”) + ” ” + [Release Event (from Change Tracker)]@row

    I wrapped with IFERROR in case the Release Event Start Date column was blank.

    Thanks Peggy