Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(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.

Task Formula for Bar

2 replies [Last post]
Chris Lothian
User offline. Last seen 1 year 15 weeks ago. Offline
Joined: 18 May 2007
Posts: 34

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.

Replies

Craig Adams
User offline. Last seen 2 years 46 weeks ago. Offline
Joined: 18 Dec 2011
Posts: 32

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

Mike Testro
User offline. Last seen 33 weeks 9 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4418

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