Reply To: Pulling the date into a text column

Peggy,
Yes! This is doable. You are close. Since you are converting the date to text, you don’t need the DATE() function. Also, because the year(), month(), and day() functions return numerical values, Smartsheet will try to add them vs concatenating them.

That is easy to fix however! All you need to do is add an empty space with double quotes are the very beginning of the formula, and that will force Smartsheet to concatenate the numbers instead of adding them.

Here is the formula I used in the attached screenshot.

=”” + YEAR([Release Event Start date]@row) + MONTH([Release Event Start date]@row) + DAY([Release Event Start date]@row) + ” ” + [Release Event]@row