Calendar month text field sorting

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Acknowledged
I'm working with a text multiple choice field that is used to choose a month of the calendar year. The months are listed as the options in the dropdown and I've chosen for them to 'Sort in this order', so they will sort January-December. This works fine while using the field to sort reports. But when used a Dynamic Filter this field defaults to sort alphabetically. Is there a way to force it to sort January-December?

Photo of Heather Bryant

Heather Bryant

  • 1,106 Points 1k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,796 Points 50k badge 2x thumb
A worka round is to create a new formula text fields use as a Dynamic Filter which will result in values like


You would need to have a leading space in front of the months from1-9