group by options are limited?

[marvaddi]

So I'm trying to group my items according to their "type". and "type" is a column that takes three entries: Sold, Selling, and Kept. Now, I'm trying to group them so that the first type that i can see is Selling, then kept, then Sold. But appsheet just groups them alphabetically like (sold, selling,kept). is there a way around this.?i was thinking to rename them like this, 1selling, 2kept, 3sold. but this is not very pleasant to look at, i thought i  might get some advice from here. any ideas?

[Suvrutt_Gurjar · Accepted solution]

If you are using an enum type for the "Type" column, please keep the order of that column entries  as "Selling", "Kept" , "Sold" to achieve the desired group by order.

[marvaddi]

Hey suvrutt, i do have them as an anum and they are ordered as I want, but it still does not show in the order is want it 😞

[Suvrutt_Gurjar]

Oh , okay. You may want to share how you have set up the column and view.