Sort text based month's name

AppSheet AppSheet Q&A
1

Hello guys,

I have column [month] with text type and using formula

INDEX(
LIST(
“January”, “February”, “March”, “April”, “May”, “June”,
“July”, “August”, “September”, “October”, “November”, “December”
),
MONTH([planned_start_date])
)

it works well.

I need to sort them by month name (January to December) on deck group not alphabetically. Does that make sense?

Thank you for your help.

2

Set your column type to Enum, and list the month names in the desired order as allowed values. Then sort by this column in your view.

4 Likes
3

Waw, so simple solution and it works well.

I used virtual column to sort it with this formula at first

IFS(
[Month] = “January”, CONCATENATE(“1.”,“January”),
[Month] =“February”,CONCATENATE(“2.”,“February”),
[Month] =“March”,CONCATENATE(“3.”,“March”),
[Month] =“April”,CONCATENATE(“4.”,“April”),
[Month] =“May”,CONCATENATE(“5.”,“May”),
[Month] =“June”,CONCATENATE(“6.”,“June”),
[Month] =“July”,CONCATENATE(“7.”,“July”),
[Month] =“August”,CONCATENATE(“8.”,“August”),
[Month] =“September”,CONCATENATE(“9.”,“September”),
[Month] =“October”,CONCATENATE(“10.”,“October”),
[Month] =“November”,CONCATENATE(“11.”,“November”),
true, CONCATENATE(“12.”,"December”)
)

thanks Sir!

2 Likes