Hi All,
Does anyone know how to get a formula that displays information about a task for the bar (whole line)?
e.g.
I have mutliple tasks per line, and 1 task on the line has a start constraint flag on it. I want the formula to flag up if the task isn't starting on the day of the constriant.
The formula i have so far is below, but i can only get it to work when I display task per line;
IF((Type="Task" OR Type="Expanded Task") AND (Task.CodeLibrary(35,0,na)="ABC"),IF( StartConstraintDate=Start,Bar.NONE,Bar.HIGH),Bar.NONE)
The result is a RAG, but as i stated above, it only displays properly when I display task per line, when the bar is on 1 line the RAG displays Grey (NONE). Thanks, Chris.