Automatically sort issues in a column

Question

Hey guys!

I'm putting together a board to organize my personal tasks.

In this borad there is a column called Scheduled Tasks and I would like that when a new issue is inserted in this column, the column would be automatically sorted by ascending Start or Due date.

I tried to use the Automation for this, but I didn't find any column sorting function.

Could you help me on how can I do it in Jira?

Regards,

Rafael

Bill Sheboy · Answer

Hi @Rafael de Aquino Cunha -- Welcome to the Atlassian Community!

If you are in fact creating a board for only your use...

A board is a view of issues, based on a saved filter.  If you want the issues displayed in a particular order, you may add an ORDER BY expression to the saved JQL filter.  This would match what you describe.  This orders all issues on the board, and not for just one column.  That is not possible with out-of-the box features of Jira...and would probably lead to confusion when an issue transitions to another status / column.

Please note well: the drag-and-drop feature of boards (to re-order issues) only works when a board's filter uses an ORDER BY Rank ASC expression.  And that will not work for your personal board...and that is probably okay...If the issues on your board are also on other boards (e.g., for your team) you may not want to drag-and-drop to change the Rank as that will impact the planning your team and product owner have agreed to use.

Kind regards,
Bill

Michael Yaroshefsky - Visor for Jira · Answer

Hi @Rafael de Aquino Cunha

Welcome to the Atlassian community!

As far as I know, Jira doesn't have a built-in automation rule to automatically sort issues by their ascending start or due date in a column.

You can try a few things:

1. Use a custom script or a piece of code that you can use to automate tasks in Jira. Atlassian's marketplace has a Script Runner for Jira plugin that might help.
2. Search the Atlassian marketplace for a third-party app to help you build custom rules for custom columns.

Best of luck with your planning