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.

L_123

I've posted a resource below for your other question.

https://help.smartsheet.com/function/networkdays

 

Ben Donahue

Thank you so much. Very elegant answer. Just like casting variables...love it!

Ben Donahue

Very clear and succinct resource. I'm embarrassed that I didn't find it myself. Thank you again.