Formatting Dates
I am copy and pasting reference data that contains dates as text. How can I link to a field and get it to format it as a date. The data looks like this Tuesday, August 16, 2022, but Smartsheet does not recognize it as a date.
I tried this
=[OPD Data]24{DATE(2021,5,5)}
Answers
-
Hi @smeyermmec
This formula will work and should work for all months, if the structure of your import data changes you will need to tweak the formula
=LEFT(RIGHT([Test date]@row, 8), 2) + "/" + IF(CONTAINS("January", [Test date]@row), 1, IF(CONTAINS("February", [Test date]@row), 2, IF(CONTAINS("March", [Test date]@row), 3, IF(CONTAINS("April", [Test date]@row), 4, IF(CONTAINS("May", [Test date]@row), 5, IF(CONTAINS("June", [Test date]@row), 6, IF(CONTAINS("July", [Test date]@row), 7, IF(CONTAINS("August", [Test date]@row), 8, IF(CONTAINS("September", [Test date]@row), 9, IF(CONTAINS("October", [Test date]@row), 10, IF(CONTAINS("November", [Test date]@row), 11, IF(CONTAINS("December", [Test date]@row), 12, "Error")))))))))))) + "/" + RIGHT([Test date]@row, 4)
Hope it helps
Thanks
Paul
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!