Can you help me with highlighting the OVerdue, Approaching and missing due dates please?

Question

Hi, I can't figure out what I'm missing. I want to see the field data (due dates) in the column but then the over due, approaching and missing due dates to be highlighted.

* I need the date to display but the background to be red and text to be white if the date is overdue.
* The date to display but the background to be orange and text to be red if its within 7 days from now.
* And the text "Needs Due Date" in blue is the due date is missing

This is what I have so far but it's incorrect. I'm struggling to show the date in the column.

IF dueDate < today(): ":panel{color=white backgroundColor = red}"

ELSE IF DAYS_BETWEEN(today(), dueDate) <= 7: ":panel{color = red backgroundColor=orange}"

ELSE: ":panel[Needs Due Date]{color=blue}"

Matthias Gaiser _K15t_ · Answer

Thank you for providing the context. I've found this documentation page quite helpful. It says, it follows this pattern:

:panel[text]{color=white backgroundColor=green}

So, I think, you've only missed the text in the square brackets and should alter it to something like this:

IF dueDate < today(): ":panel[dueDate]{color=white backgroundColor = red}"

ELSE IF DAYS_BETWEEN(today(), dueDate) <= 7: ":panel[dueDate]{color = red backgroundColor=orange}"

ELSE: ":panel[Needs Due Date]{color=blue}"

If the date is not in the format, you'd like it to have, you could also use the FORMAT_DATETIME function as documented here.

emma.caddow · Answer

It's in the formula column on Structure

Hannes Obweger - JXL for Jira · Answer

Hi @emma.caddow

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, I think you'd like 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 range of advanced features, including support for conditional formatting.

With conditional formatting, you can define conditions on your issues, and if these conditions are fulfilled, set the background and text color of either the entire row, or specific cells, like e.g. so:

This is really just one example - you have full control over the conditions and colors you want to use.

Conditional formatting also works great in combination with JXL's other advanced features, such as (configurable) issue hierarchies, issue grouping by any issue field(s), or sum-ups.

Any questions just let me know,

Best,

Hannes