True/False indicator - all task predecessors complete MS-Project 2010

[jdove78]

I would be grateful if someone could help me create a task field that would tell me if all the task's predecessors are complete. This would allow me to do some desperately needed filtering.
Thanks in advance,
Jay

 

[JulieInMaine]

Hi Jay,
Custom fields may only refer to the current task and cannot reference other tasks. The only option would be to use VBA to cycle through each task and check it's predecessor. Jack Dahlgren has a "Trace" macro on his web site which will filter a project for the selected task's predecessor - but it does not deal with completion data. You may be able to modify the macro.

For Jack's macro see:

http://masamiki.com/docs/trace-task-dependencies.html

Julie

 

[jdove78]

Hi Julie,

Thanks for your response. I reviewed Jack's macro which was helpful as indicated that it may be difficult to create a solution. Jack's macro appears to provide information a task at a time and may have a hard time identifying tasks in other parent groups.

Do you believe it would be possible to create a macro that will set a true/false indicator to a task field to indicate if ALL predecessor tasks are 100% complete?

-J

 

[JulieInMaine]

Hi Jay,

I'm sure it would be possible, but sadly, I'm not the person to assist. If you have some skills in VBA, you might consider posting to the Microsoft forum for programming in Project. See:

http://social.technet.microsoft.com/Forums/en-US/project2010custprog/threads

When you post, be sure to specify what version of Project you are using.

Good luck,
Julie

 

[jdove78]

Julie,

Thanks for your reply. It appears that Andrew was kind enough to make a first pass at a solution at the forum you suggested:

http://social.technet.microsoft.com...g/thread/9f960da1-2ef8-4d97-a02c-20f218c885bc

I had posted the question in a few places as I was skeptical that anyone would see it; I was proven wrong and will limit my questions to a single forum going forward.

Thanks again for your help, I will continue following-up on this in the technet forum.

-J

 

[JulieInMaine]

You're very welcome, Jay. The Microsoft forums certainly get more traffic.

Julie