nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Structure formula - issue status dependency

Иван Беляков

Hello. So I am trying to tune structure gantt to show if an issue transitioned further than "To do" status as planned or not. To do so, I need to check two things:

1. If an issue start date is in the past

2. If an issue is still in the "To do" status

Then to highlight issues that have start date in the past and still in "To do" status.

What I'm trying to put in the formula:

IF (dueDate < today() Status="TO DO", "{color:red}Not started{color}",
dueDate > today(), "{color:green}ОК{color}",
dueDate = today(), "{color:orange}Should start today{color}")

Where "dueDate" is GanttStartDate.

Apparently, there is an error in the first line of the formula, but I'm not sure how to fix it.

Would apreciate any help

Accepted answers

Dionathan Lopes {ALM Works}

Hello Иван Беляков

Thank you for sharing your Structure Formulas question here on the Atlassian Community

Here is an example formula you could use as a template

IF(
(duedate < today() AND Status = "TO DO");
"{color:red}Not started{color}";
IF(
(duedate < today() AND Status != "TO DO");
"{color:green}ОК{color}";
IF(
days_between(today(), duedate)=0 AND Status = "TO DO";
"{color:orange}Should start today{color}";
IF(
duedate > today();
"{color:green}ОК{color}"))))

You would also need to change the Format to "Wiki markup", by selecting it on the dropdown list right next to the "Options" field. Please refer to this article for more information - https://wiki.almworks.com/display/structure/Formulas