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.
Hi Chris,
Create a code for your key deliverable and apply it to the task with the constraint flag on it then insert a column that sources/filters for that code to display the RAG column.
Kind regards,
Craig
Hi Chris
Asta do not make it easy to apply formulas to the spreadsheet.
They should at least have a library of common formulae.
Perhaps this will come up in version 13.
Best regards
Mike Testro