I have a month field in my spreadsheet that c...

(Calvin Lindsay) #1

I have a month field in my spreadsheet that contains dates in each month of the year. In the appsheet view I have grouped the data by month and sorted in ascending but it sorts alphabetically rather than Jan, Feb, Mar etc. Is there a simple way around this?

(Aleksi Alkio) #2

Unfortunately we don’t have direct way to sort the view with another column. You would need to have a prefix for your month… like 1 - Jan, 2 - Feb etc.

(Praveen Seshadri (AppSheet)) #3

You could make the month an Enum column type. In this case, it sorts the data in the order of the enum values. So if you list the values as Jan, Feb, etc, then it will sort that way

(Calvin Lindsay) #4

Thanks!