show lag time in gantt chart

A

alppix

Is it possible to show lag time in the gantt chart? Or in own field?
(ms project 2003)

I know that I can see it from predecessors field, but I would like to
have it in own field or in gantt chart.

I was able to make own custom field which shows it somehow, but it
didn't work if task has more than one relation.. That own field just
had formula which collected character from wanted index in predecessor
field.. From that field I could show it in the gantt also.

So, is there any proper way to do this or does anyone know any good
formula how to get the information needed?
 
D

Dale Howard [MVP]

alppix --

In your situation, I would definitely not recommend that you use a custom
field to indicate the amount of Lag, for the reasons you have already given.
To create a formula to extract the Lag time, the formula would need to
locate the plus sign character in either the Predecessors or Successors
field, and then extract all characters to the right of the plus sign,
stopping when the formula hits the first comma character (indicating an
additional dependency). If you are competent with Project VBA, writing a
macro would probably be easier than writing a formula for your purposes.

If it were me, and I needed to quickly show all tasks with Lag time, I would
do the following:

1. Create a task Filter called Tasks with Lag. The Filter would do a
"Contains" comparison for the plus sign, indicating that a task has Lag
time.
2. Create a new task Table called Lag that contains the Indicators, Task
Name, Predecessors, and Successors columns (plus any others you wish to
see).
3. Copy the Gantt Chart view and create a new custom task View called Tasks
with Lag containing the Lag table and the Tasks with Lag filter. In the
View definition, select the "Highlight filter" option.

When you apply the View created in step #3 above, the system displays your
Lag table with a Gantt Chart and then highlights all tasks with Lag time.
Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top