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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!