Date Format Question
Hello Smartsheet Community,
How can I get the Date Helper column below to automatically show the date format as D-M-YYYY? There is a formula in that column and it's a date column. When I click on the date format button and select another format type, it does not do anything. The D-M-YYYY format seems to be the only one that works with the month formula.
Below is what I'd like it to look like. I did this manually and would need it to be automatic.
Thank you!!
Answers
-
=LEFT([Date Column]@row, FIND(" ", [Date Column]@row, LEN(LEFT([Date Column]@row, FIND(" ", [Date Column]@row) - 1))))
Looks like your initial formula is including a space at the end. I used len to subtract 1 from the result.
...
-
Thank you for your response! How can I get the date format to show as D-M-YYYY even though there is a formula in the column? I have the formula applied to the whole column. I can't get mine to show like yours with the formula you shared.
I appreciate you taking the time to help!
-
I figured out another solution :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!