Sort PRs in Project by Milestone in date order?

[Paul Barrett (paul-barrett)]

In a project with Milestone as a column it must be possible to sort by order of actual date, but I can't seem to work out how to do this - grouping only puts e.g. "Spring 2026", "Spring 2027", "Autumn 2026" together but not in order of time. Is this because the field for Milestone is just text rather than a date?

E.g. https://github.com/orgs/MetOffice/projects/442/views/1?groupedBy%5BcolumnId%5D=Milestone

[iboutle]

I haven't worked out how to do this - I wonder if it would be better to rename the milestones into something that can be sorted in chronological order, e.g. 2026-07, 2026-11, 2027-03 etc?

[Yaswant Pradhan (yaswant)]

Unfortunately, the item sorting in Project board is text based.
However, you can add a custom "Iteration" field (say Season with specific date bounds) and manually add the tag in table view. Then you can group by Season. Let me take a look.

Update: Hopefully that's sorted by season correctly now