Formula to indicate all predecessors are complete

[James]

Sorry, new to MS Project. I need to create a custom field(column) with
traffic indicators to show that all of teh predecessor tasks are complete. Is
this possible? I appreciate any help on this. Jim

 

[John]

Sorry, new to MS Project. I need to create a custom field(column) with
traffic indicators to show that all of teh predecessor tasks are complete. Is
this possible? I appreciate any help on this. Jim

James,
Welcome to Project. The simple answer is "no". What you want to do can
not be done with a formula in a custom field. The reason is, a formula
can only act on data for that task line and completion of a predecessor
task is of course data on that other task line.

You could however do what you want with a VBA macro. It would involve
looping through all predecessors of each task and then setting a flag to
enable whatever traffic indicators you want.

John
Project MVP

 

[Jim Aksel]

I have a macro that will do something similar. Go to my blog and fill out a
contact form. I will send you something to get you started.

The code is VB.NET; similar, but not identical. It will get you started.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Jim Aksel]

Check your e-mail.