Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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?

1 answer

1 accepted

4 votes
Answer accepted

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!

Thanks for sharing your self-discovered answer with the community, Johanna! :) 

-dave 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you