convert a date (Monday of each working week) into a text value
Answers
-
Hello!
I am trying to convert a date (Monday of each working week) into a text value in a drop down menu so that it can be used as a sort option for card view and we can easily allocate tasks to reource etc
I have successfully converted the date to text using *"" ... however the text returned is dd/mm/yy - 01/02/23 etc ... and the card view does not recognise the "date order" ( so wc 01/02/23 would be followed by wc 01/03/23 ... rather than 08/02/23).
How can I get either - start the original week dates to be useable as cards ( much like grouping by date in a report - or the text to return yy/mm/dd .... which would solve the issue?
Thank you for any advice!!!
-
This formula would convert your date into the format you specified:
=RIGHT(YEAR(Date@row), 2) + "/" + RIGHT("0" + MONTH(Date@row), 2) + "/" + RIGHT("0" + DAY(Date@row), 2)
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!