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.
Help Article Resources
Check out the Formula Handbook template!