How to sort it by year month?

I’m having a hard time to create to group by year month in a sortable way.

Hi Walter! One way I have solved this issue is using the date.Year(), date.Month(), and date.Day() formula to convert a date formatted column into separate columns for whichever component of the date you are looking to sort.

This would result in March becoming 3, and you can group or sort that column numerically.

Hope this helps!

1 Like