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

Jared Rakich

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

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.

Paula Mandile CHESS

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)), "")

Cheers

Paula