convert a date (Monday of each working week) into a text value

This discussion was created from comments split from: How can I convert a date to plain text?.


  • 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!!!

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!