Determine if uncompleted work exists in the past

[ProjMacroGuy]

As a weekly practice we perform the task of rescheduling uncompleted
work using "Tools">"Tracking">"Update project">"Reschedule uncompleted
work
to start after:" Is there a way to create a calculated field or write
a macro that indicates is a task has uncompleted work in the past?

 

[Jan De Messemaeker]

Hi,

How about

(Thetask.remainingwork>0) and (thetask.start<vba.date) and _
((thetask.actualwork=0) or (thetask.resume<vba.date))

HTH

 

[ProjMacroGuy]

Hi Jan!

I was not familiar with how the task.resume date until your post. I
thought the field was blank until the task was actaully split when the
resource logged actuals creating a gap in actuals.

Thanks for your help.

-Brad