I want to sorting by month.

[sevvalk]

=if([Date]<today(),'2023-Delayed', [Year]& '/' & [Month] )  I wanted to put together year and month but sorting is not by month. I added the chart photo. How can I do that?

[Aditya_Chitale · Accepted solution]

In sorting tab, disable the auto sort option and check 'Sort by expression' and use match() condition to apply custom sorting. If just match() does not work, try using pick() combined with match().

Eg: match(MonthField, 'Oca' , 'Sub' , 'Mar' , 'Nis' , 'May' , 'Haz' , 'Tem' , 'Agu' , 'Eyl' , 'Eki' , 'Kas' , 'Ara')

or

pick(match(MonthField, 'Oca' , 'Sub' , 'Mar' , 'Nis' , 'May' , 'Haz' , 'Tem' , 'Agu' , 'Eyl' , 'Eki' , 'Kas' , 'Ara'))

Regards,

Aditya

[sevvalk]

match(MonthField, 'Oca' , 'Sub' , 'Mar' , 'Nis' , 'Mayıs' , 'Haz' , 'Tem' , 'Agu' , 'Eyl' , 'Eki' , 'Kas' , 'Ara')  It worked. Thank you so much.

[freak22]

Just the one. So you have a date field 1/1/2022 and create a month column with text, January, and then a month number column 1, you can sort month by month number so January would be first, not April. The Sort By Column only changes how the Month column sorts, not anything else. So if you had a day of week column, Monday, you’d need another number column to set it by…