When a Buisiness Project issue is about to be due, color should change

[Dave Duijvekam]

Hello all,

I have a challenge:

For our business projects, we would like the color of the due date or ID of the problem to change.

Same as the SLA does for service projects.

In this case color red 48 for due date/time

Any idea if this is possible at all, I could not find anything....

Regards,

Dave

[Mikael Sandberg · Accepted solution]

It can be done, but you would need an app from the Marketplace in order to do it. You could then use automation to set the color based on the due date.

[Hannes Obweger - JXL for Jira]

Hi @Dave Duijvekam

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using 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 number of advanced features, including support for conditional formatting: With conditional formatting, you can define conditions on any issue fields, and if a conditional is fulfilled, set a background and content color on either the entire row, or a particular cell.

This is how it looks in action:

Conditional formatting also works in combination with JXL's other advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), or sum-ups. Since every JXL sheet is powered by a JQL statement, you can easily use in (and across!) your business projects, as well as projects of any other project type.

Any questions just let me know,

Best,

Hannes

[Dave Duijvekam]

HI Hannes,

Thank you for your reply.

Managment has to decide if they want to spent money :)

Regards,

Dave