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.
Solved! Go to Solution.
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.
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.
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!
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |