Text to Date
I have a column that the data is in DD/MM/YY but in text. I am trying to turn it into a date in a column next to it. Can someone help!!!
Answers
-
hi @KatieB
but what's the problem?
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
-
The data is a text entry but i would like it to read as a date DD/MM/YYYY.
Basically i have a second column that i wanted to use the month format but because it is Text i do not know how to extract the month
-
hi @KatieB ,
did you read this post? https://community.smartsheet.com/discussion/86372/text-to-date-field
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
Help Article Resources
Categories
Check out the Formula Handbook template!