In AppSheet, I want to group by month using the Group by setting, with the months January to December. However, instead of displaying them in the order January, February,… December from the bottom, I want to display them in the order April, May,… December, January, February, March. The month column is of Ref type and refers to a Month Master table.
One way is to use number before the real month name so it will sort the order based on that.
Thanks
Like 0_April, 1_May, 2_June, … , 8_December, 9_January, …???
It’s awkward to have this notation even when displaying groupings, but is it unavoidable?
Cria uma coluna virtual e usa como numero e usa essa formula !
SWITCH(
MONTH([DATA DA COMPRA]),
1, "JANEIRO " & " " & YEAR([DATA DA COMPRA]),
2, "FEVEREIRO " & " " & YEAR([DATA DA COMPRA]),
3, "MARÇO " & " " & YEAR([DATA DA COMPRA]),
4, "ABRIL " & " " & YEAR([DATA DA COMPRA]),
5, "MAIO " & " " & YEAR([DATA DA COMPRA]),
6, "JUNHO " & " " & YEAR([DATA DA COMPRA]),
7, "JULHO " & " " & YEAR([DATA DA COMPRA]),
8, "AGOSTO " & " " & YEAR([DATA DA COMPRA]),
9, "SETEMBRO " & " " & YEAR([DATA DA COMPRA]),
10, "OUTUBRO " & " " & YEAR([DATA DA COMPRA]),
11, "NOVEMBRO " & " " & YEAR([DATA DA COMPRA]),
12, "DEZEMBRO " & " " & YEAR([DATA DA COMPRA]),
“Invalid”
)
If you can use an Enum column and you manually add your months in a correct order in “Values” option, your grouping will follow that order.
This has stopped working for me. When I asked Support about it, I was told this (now-seemingly-broken) behavior is correct and intended.
Yes, I also tested setting up an enum because I wanted to respond to this question. But I also could not get it working.
This is the enum I had created.
I tested and for me it works just fine.
Okay Aleksi. Thank you for the confirmation. I will retest tomorrow and revert. Maybe I missed some obvious point in my configuration.
I tested this with another account and it didn’t work. I have a vague memory from 3…5 years ago that my personal account was excluded from the rollout and that’s why the behavior is different.
How would I get mine fixed? What language would Support respond to?