Create a formula for overdue date

Amedeo_99jsp5

Good morning,

I would like to create a formula in JIRA Structure in order to highlight the overdue days comparing the date of today and the field Target Start, but only for the issue type: Story.

I would also that the cells that fulfills this parameter are colored in red.

I used this formula, but it doesn't work:

IF issueType = epic AND IF TargetStart < NOW(): DAYS_BETWEEN(TargetStart, NOW()) CONCAT " days late"

Can you help me?

Thanks

amedeo

Evgenii

Hi, @Amedeo 

You can try this:

IF(issuetype='Epic',
IF(duedate, 
IF(
    duedate < now(), "{color:red}*Failed*{color}", 
    (now() - creationDate) <= (totalTime / 100 * 30), "{color:green}*<30% time left*{color}", 
    (now() - creationDate) > (totalTime / 100 * 30) & (now() - creationDate) <= (totalTime / 100 * 70), "{color:orange}*30% - 70% time left*{color}",
    (now() - creationDate) > (totalTime / 100 * 70), "{color:red}*70% - 100% time left*{color}"
)))