(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
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.
Printer-friendly version
Send to friend
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
Email: PPadmin@planningplanet.com
Replies