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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!