Adding a column in Jira Filter to show if an issue is Past/Near/Far from/Missing a due date

Question

I have a filter showing all issues in a project. I would like to add a column to show if an issue is

1. past due: due date > today

2. near due: due date within 2 weeks from today

3. far from due: due date beyond 2 weeks from today

4. missing a due date: due date is not filled in

could you please advise how I can show that new column, say the column name as "due date status". Thank you very much,

Valerie Knapp_dpp5c6 · Answer

Hi @Johnny Chiang , thanks for your feedback.

You would need a scheduled rule that runs each day and updates a custom field you would need to create, such as Due Date Status.

Then, based on a series of if conditions, you would update the Due Date Status for today for each issue.

Here is an example rule which you could modify for your use case https://www.atlassian.com/software/jira/automation-template-library/rules#/rule/9918938/207129065

Cheers

Hannes Obweger - JXL for Jira · Answer

Hi @Johnny Chiang

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of advanced features, including support for  conditional formatting. With conditional formatting, you can define conditions on your issues - such as different due date ranges - and if these conditions are fulfilled, set the color of either the entire issue row or a particular cell. This is how it looks in action:

This is really just one of a virtually endless number of possible views and reports; you have full control over which data you want to show and highlight. I should also add that conditional formatting plays nicely in combination with JXL's many other advanced features, such as e.g. support for configurable issue hierarchies, issue grouping by any issue field(s), or sum-ups.

Any questions just let me know,

Best,

Hannes

Johnny Chiang_xo3h1m · Answer

@VAL thanks for your suggestion but I'm not familiar with JIra Automation so would you please advise how I can initiate an automation rule? thanks,