Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

jdove78

IS-IT--Management
Oct 9, 2012
3
US
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
 
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:


Julie
 
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
 
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:


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

Good luck,
Julie
 
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:
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
 
You're very welcome, Jay. The Microsoft forums certainly get more traffic.

Julie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top