Grouping not sorting correctly on numbers? Does anyone know why?

The grouping of numbers works fine until you get to number 11.

Background: I have attempted to sort by month and knowing there is no logic to sort by month (as dropdown list) I have instead opted to use numbers as a prefix to each month. Unfortunately this causes an issue when it gets to 11. My team is loving this grouping feature but we're let down by this numbering. I know there is probably a temporary hack to get this to be in order but I thought I would understand if this is a known bug first.


  • Heather Duff
    Heather Duff ✭✭✭✭✭✭

    Have you tried putting a 0 before the one-digit months? So, it would be

    01 - January, 02 - February, etc.

    That may do the trick. I can see that it's sorting by the first digit first.

  • Yes, Heather is right

    this formula is an example of sorting YY / MM correctly.

    This will ensure Months like 10, 11, 12 do not appear ahead of lower months, like 2, 3 , 4 etc

    You'll get the idea....

    =IFERROR(YEAR([Issue Date]@row) + "/" + IF(MONTH([Issue Date]@row) < 10, "0" + MONTH([Issue Date]@row), MONTH([Issue Date]@row)), "")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!