You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
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.
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