Structure - How to output a calculated value within a wiki markup panel

Johanna Leopold

Hello,

I would like to display a formula with wiki-markup panels, but instead of returning "due soon", "overdue" etc. I want to return the days from now until due date.

It allows me to use "DAYS_BETWEEN(Today(), DueDate)" (without wiki markup) to show the days until a task is due or the following markup formula:

IF (dueDate < today(), "{panel:bgColor=red}Overdue{panel}",
DAYS_BETWEEN(today(), DueDate) <= 7, "{panel:bgColor=orange}Due Soon{panel}",
DAYS_BETWEEN(today(), DueDate) > 7, "{panel:bgColor=lightgreen}Due Later{panel}",
"")

What I would like to achieve is the first (number of days) within the coloured panels, but it fails to add calculations (or even variables, I tried with simply the due date). 

Is this even possible?

Johanna Leopold

Update: After posting, it showed me https://community.atlassian.com/t5/Jira-questions/Formula-Column-change-color-of-the-value-calculated/qaq-p/1750811 as related and CONCAT solved my problem!