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

[emma.caddow]

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. 

1. I need the date to display but the background to be red and text to be white if the date is overdue.
2. The date to display but the background to be orange and text to be red if its within 7 days from now.
3. 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}"

[Hannes Obweger - JXL for Jira]

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

[Matthias Gaiser _K15t_]

Hi @emma.caddow

welcome to the Atlassian Community.

Can you please elaborate where you're adding this code?

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}"

I'd be interested into learning where you can add this - and could possibly help displaying the value. Or was this only an example how you'd like to have it formatted?

I've recently attended an Atlassian Community Event where they've presented the app Awesome Custom Fields. If you're also fine with app solutions, I'm quite confident this app easily allows to do that.

Cheers,
Matthias

[emma.caddow]

It's in the formula column on Structure

[Matthias Gaiser _K15t_]

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.

[Nikola Perisic]

Welcome @emma.caddow 

You should be creating card colors that are based on queries. So:

• Red card -

  duedate < now()

• Orange card -

  due <= "7d"

• Blue card -

  due is EMPTY

The additional changes like card being whole colored by native Jira is not possible without installing the app.