How to sort by Sprint ASC by first non-completed sprint (if any) or last completed sprint (if all co

Hi @barnabas_makkay 

As @Marc -Devoteam- says this is not currently possible, however there are workarounds that you could use with future work items using a custom field and automation.

Firstly create a short text field 'YourSprintFieldName' e.g. 'Parent Sprint' or similar. (I only used this name as we have an existing field with that name)

Next create an automation, e.g.:

Going forwards any sprint changes will be reflected in this field and you can sort on this field.

In addition, you could add the following to your JQL to only show work items in the current or future sprints:

Sprint in (openSprints(), futureSprints())

or for completed sprints only:

Sprint in (closedSprints())