Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

sorting the issues according to estimation and due date


I need to sort issues according to a calculation of Due Date and estimation. For example- if an issue's estimation is 21 working days (in average that is a month) and an issue's due date is for one month from now- in the sorted list this issue would appear first- it has to start being handles immediately. 


On a farther note I wonder if there is a tool or search query that calculated the due date, estimation and assignee - so that for example if the employee X has 2 assigned issues with 21 days estimation- and he has a due date for 2 months from now- his topics would appear first in the search result. Or- an alert can be sent or priority field changed. Is there such tool? 

1 answer

Hi @Sharona Keren 

I do not believe there is anything in standard license, out-of-the-box Jira Cloud that can do what you ask.

Some options to try are based upon your need frequency and cost/effort to invest:

  1. Need infrequently, and little effort: export the data to a spreadsheet and perform the calculation and sort there
  2. Need a bit more frequently, and some effort: use the Atlassian provided Google Sheets or Excel addin to create/save your spreadsheet from #1 and use it repeatedly
  3. Need often, and cost is not a factor: investigate the marketplace for JQL addons which can provide calculated fields.  Check the documentation to learn if they do what you require.
  4. Need often, cannot spend money, willing to do some work: use an automation rule and a custom field to compute your sort field and use built-in advanced search to report your results

For your further note scenario, I cannot tell if you are trying to load-balance team capacity or do some type of critical path analysis.  I recommend trying to solve your sorting issue first and see if your selected solution can also help.

Kind regards,

Hi Bill,

Thank you for the detailed answer. 

I guess I'm trying to do a little bit of both, and the solution above wouldn't do it.

I need to ask something regarding the 4th solution- Is the costume field capable of having a calculation? What would that look like? Will it be updated automatically? 

What kind of automation rule did you mean?


Thank you! 

Hi Sharona,

I was noting Automation for Jira (which is built into the Cloud version).  Please look here to learn about it:

If you can base your calculation on fields in an issue, you probably can write a rule to compute the value with a rule.  It could run automatically when a source field for the calculation changes.

Please talk to your site admin about adding a custom field to store the value.  They may have other ideas how to solve the problem too.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

460 views 19 23
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you