Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Date conversion
I feel like I'm off my game today.
I hope I'm wrong here but this is what I have.
Sheet 1 has a Date column
For other design issues, that date is linked to a Text/Number formula on Sheet 2.
In sheet 2, I want to take the date and compare it to a real date in the sheet.
Addiing =[Text Column]23 to a date field results in a text.
Even if the text 'looks' correct ("07/01//16")
Am I missing a formula to convert that directly to a date?
This:
=DATE(VALUE(RIGHT([Text Column]23, 2)) + 2000, VALUE(LEFT([Text Column]23, 2)), VALUE(MID([Text Column]23, 4, 2)))
seems like a lot of effort to do that on my own.
Is there another way I'm just brain-farting on at the moment?
If not, I suggest that there should be.
Craig
Comments
-
Hey Craig-- Can you share the sheet with me? I tried to follow the steps you outlined on my end and I'm seeing the date show up as a "real date" so I assume I must be doing something wrong.
