Sort board by Start Date

[Nolan McConnell]

Hey, Jira Community! 

I'm looking to see if it's possible to sort a Jira board by upcoming Start Dates. For example, somebody starts in a week from now on top, two weeks from now below them, three weeks from now below them, etc. If the field isn't filled out I don't want to show it or show it at the bottom. If the start date is in the past I'd either not want to include it or have it at the bottom. 

Appreciate any feedback ahead of time. 

Thanks! 

[Alex Koxaras -Relational- · Accepted solution]

Hi @Nolan McConnell 

Create and save a filter with the desired JQL. In your case and based on what you said I would create the following:

project = dsp and "Start date[Date]" is not empty and "Start date[Date]" >= now() ORDER BY cf[10015] ASC

Replace the project name with your own and the cf[10015] with the start date CF id. It is important to keep the order by start date asc on the end of your jql.

Then go and create a kanban board using the saved filter and you will have your board without being able to move any issues in the same column. "Ranking" will be enabled and based on the "Start Date". Any issues that have start date older than today's, it will not be visible. Past issues as well.

Let me know if that helps.

[Nolan McConnell]

That did help! Thank you so much. I was missing the now() portion of that filter. 

[Alex Koxaras -Relational-]

@Nolan McConnell glad to be of help! Kindly mark my answer as accepted in order to help others with the same question. Thank you!