Displaying a date in a non-date column
![Ben Donahue](https://us.v-cdn.net/6031209/uploads/drupal_profile/files/2019-05/7d/c7/n7dc76a8f588de66bb9113372bae7271f.jpg)
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)
Comments
-
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.
-
I've posted a resource below for your other question.
https://help.smartsheet.com/function/networkdays
-
Thank you so much. Very elegant answer. Just like casting variables...love it!
-
Very clear and succinct resource. I'm embarrassed that I didn't find it myself. Thank you again.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!