0

Is it possible to create a custom field that tests if a completed task has a predecessor or successor with lag?

Update: I've solved my problem bellow.

I had inherited a large project which had not been properly progressed in some time and whose execution logic had changed significantly since the last baseline. To get up to speed I was creating a few custom fields to help identify tasks to watch when picking it apart and putting it back together again. My predecessor had included a lot of lag in his linkages, which a) I didn't want to progress and b) I wanted move into clearer to understand tasks rather than keep in the linkages.

  • 1
    Welcome to PMSE! This type of question is certainly on-topic as long as you provide sufficient background. Please improve your question by describing what you've already tried, and why that didn't work for you. – Todd A. Jacobs Nov 11 '13 at 16:10
  • Hey Trigger, welcome to PMSE! The main idea in the request for more information in the question is simply to help others with the same problem find it from Google. It looks like you have an answer, which is great. Sometimes askers wonder how they can give back when they're only asking questions. On our site, we really value questions and question-askers, so the more information, the better. Hope this helps! :) – jmort253 Nov 12 '13 at 1:50
1

You can quickly filter tasks that have lead or lag using autofilters on the predecessor and/or successor field. Use contains + to filter for tasks with lag. You can apply autofilters to multiple fields (columns) to further narrow down whether the task is complete (filter on % complete field).

  • This worked for what I needed at the time, but I also was looking to create a graphical indicator test (which I wasn't clear about in the original question and have updated above, and bellow). – Trigger-Cut Dec 11 '13 at 3:41
0

Sorry for the late response. This is the test I was actually trying to construct.

This is used to check if a task with 100% completion has a Predecessor or Successor with lag.

I'll edit the original question to be more specific.

IIf(
    ((InStr(1,[Predecessors],'+') Or InStr(1,[Predecessors],'-')) 
    Or 
    (InStr(1,[Successors],'+') Or InStr(1,[Successors],'-'))<>0)
    And 
    [% Complete]=100,1,0
    )

*Formatted for readability.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.