Sorting in a report

Melitta ✭✭✭✭✭
edited 11/03/22 in Smartsheet Basics

I am filtering information on a report by Start Date in between Jan 1 and Dec 31 of 2022, start date is in the future, and in the next 120 days. Grouping it by month (January - December). This is populated by a helper column formula that takes the month from the start date and converts to the month.

I am grouping the report by month and sorted.

However, it shows March followed by January and then February.

Why? clearly it's not alphabetical. How do I get it to sort January, February, March....?

Any thoughts?

This form is not allowing me to upload a screen shot.


Best Answers