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

[Dionathan Lopes {ALM Works} · Accepted solution]

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

Please let me know if it helps.

Best Regards,
Dionathan Lopes
[ALM Works]

[Иван Беляков]

Thank you mate, it worked!

[Dave Rosenlund _Trundl_]

Hi, @Иван Беляков. You may be interested in the Structure 7 / Formulas / Expr 2 Bootcamp.

Best,

-dave