Displaying a date in a non-date column

Ben Donahue

I am trying to display the earliest  date in the "Start" column and the latest date in the "Finish" column, thereby getting the start and end dates of the whole project. I can get these, and display them in a third column formatted as a "date" column. Now, I want to include this text (the date) in a forth column formatted as text. I though there might be some kind of "VALUEOF" formula that would grab the date as a string and display it as such, but cannot find this method, or formula).

My question is, is there any way to display a date in a column formatted as text?

Thank you.

(My next question will be about how to find the number of workdays between two dates)

L_123

Alright, there are several ways to go about this. The obvious way is to parse the parse of the date apart then together in whichever way you like. An example is below

=DAY(C3) + "/" + MONTH(C3) + "/" + YEAR(C3)

But while that makes sense, there is an easier way to do this if you understand how smartsheet functions.

=C3 + ""

this forces smartsheet to recognize the resulting value as text, and as such treats the date cell as text too.