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?
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.
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
Thanks!
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |