Create a formula for overdue date

[Amedeo]

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 · Accepted solution]

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

[Evgenii]

BTW, Structure Team has telegram chat for community, and very skilled community team with quick support.
https://t.me/structure_community

[Amedeo]

Thank you @Evgenii ,

it works, thanks.

Amedeo

[Evgenii]

Great!
Mark please my answer as accepted, it will be helpful for people, searching similar information.