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:24 pm #597
Darren
Keymaster

    Add some if conditions for the Month and Day are less than 10 and if so add in a 0 as follows:

    =”” + YEAR([Release Event Start Date]@row) + IF(MONTH([Release Event Start Date]@row) < 10, 0) + MONTH([Release Event Start Date]@row) + IF(DAY([Release Event Start Date]@row) < 10, 0) + DAY([Release Event Start Date]@row) + " " + [Release Event (from Change Tracker)]@row