Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sevvalk
Creator
Creator

I want to sorting by month.

=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?

1 Solution

Accepted Solutions
Aditya_Chitale
Specialist
Specialist

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

View solution in original post

3 Replies
Aditya_Chitale
Specialist
Specialist

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
Creator
Creator
Author

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

freak22
Contributor
Contributor

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…