Filter For Split Tasks

Question

When task progress is updated, the task may get split when move incomplete parts to the status date. On some tasks they get split more than once.

I want a filter for split tasks.

Had thought IIF(stop<>resume, yes, no) might do it, but stop and resume are both equal to the actual finish if the task is 100% complete, even if the task is split.

So I am stuck for the moment. What else is filterable for split tasks?

Answer 1

Using the following formula will yield the desired results, regardless of the completion rate.

IIf([duration]/480=ProjDateDiff([start],[finish])/480,0,1)

HK

Answer 2

Thank you. Very neat. Needs this.

IIf(Duration=0,0,IIf([Duration]/480=ProjDateDiff([Start],[Finish])/480,0,1))

Answer 3

HK,

I like it. Your custom field formula makes use of the fact that for a split task the calculated duration span will always be longer than what is displayed in the Duration field.

John

Answer 4

IFF() formula in quick filter works, but not for tasks 100%.

Answer 5

Trevor,

Are you just looking to identify (i.e. filter out) all tasks with at least one split or something else? Perhaps a screen shot of an example.

Assuming you are just looking for a method to identify all tasks with splits whether 100% complete or not, run this simple macro and then filter on the Flag1 field. Note the flag is cleared before each task is tested so no need to "tidy up" after running the macro.

Sub DetectSplitTasks()
Dim t As Task
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
t.Flag1 = False
If t.SplitParts.Count > 1 Then t.Flag1 = True
End If
Next t
End Sub

John