Filtering for only cross-project links

[Andrew K]

In a master with inserted projects that have external links, I want to
display only those cross-project links. I've tried Predecessors contain "\\"
and Predecessors contain \\. I can't use Predecessors not equal to (blank)
because the projects have internal task dependencies and they all display.
What would be the syntax for not within (a range from 0 to 1000)? I could
then say Predecessors not equal to (blank) AND Predecessors not within ...

Any ideas? Thanks

 

[JulieS]

Hi Andrew,

Here's a formula I posted awhile ago which may help:

After some *quick* testing, I believe the following formula will work in a
Flag field:

IIf(Instr([Predecessors],"\")<>0,"Yes",IIf(Instr([Successors],"\")<>0,"Yes","No"))

This will display a Yes if the task has either an external Predecessor or
external Successor. You can then filter looking for only Yes in the flag
field.

Hope this helps. Let us know how you get along.

Julie

 

[Andrew K]

Julie,
Your formula works fine. I have two linked projects, and the filter based
on the customized Flag field displays the Predecessor and the Successor.
Now, when I insert both projects into a master parent, I get the same result
with just the first part : IIf(Instr([Predecessors],"\\")<>0,"Yes","No") -
i.e., the Predecessor and Successor tasks both display. Why is that?
Thanks,
AndrewK

Hi Andrew,

Here's a formula I posted awhile ago which may help:

After some *quick* testing, I believe the following formula will work in a
Flag field:

IIf(Instr([Predecessors],"\")<>0,"Yes",IIf(Instr([Successors],"\")<>0,"Yes","No"))

This will display a Yes if the task has either an external Predecessor or
external Successor. You can then filter looking for only Yes in the flag
field.

Hope this helps. Let us know how you get along.

Julie

In a master with inserted projects that have external links, I want to
display only those cross-project links. I've tried Predecessors contain
"\\"
and Predecessors contain \\. I can't use Predecessors not equal to
(blank)
because the projects have internal task dependencies and they all display.
What would be the syntax for not within (a range from 0 to 1000)? I could
then say Predecessors not equal to (blank) AND Predecessors not within ...

Any ideas? Thanks

 

[JulieS]

Hi Andrew,

Glad to know the formula worked and thanks for the feedback.

Without seeing your project file, it is only a guess, but I assume the
reason why you only need the first part of the formula in a master project
is that if a task is an external successor to one task, it is also an
external predecessor to another task in the project. Tasks actually entered
into the master are internal -- all others (from the subproject files) are
external.

Hope this helps.

Julie

Julie,
Your formula works fine. I have two linked projects, and the filter based
on the customized Flag field displays the Predecessor and the Successor.
Now, when I insert both projects into a master parent, I get the same
result
with just the first part :
If(Instr([Predecessors],"\\")<>0,"Yes","No") -
i.e., the Predecessor and Successor tasks both display. Why is that?
Thanks,
AndrewK

Hi Andrew,

Here's a formula I posted awhile ago which may help:

After some *quick* testing, I believe the following formula will work in
a
Flag field:

IIf(Instr([Predecessors],"\")<>0,"Yes",IIf(Instr([Successors],"\")<>0,"Yes","No"))

This will display a Yes if the task has either an external Predecessor or
external Successor. You can then filter looking for only Yes in the flag
field.

Hope this helps. Let us know how you get along.

Julie

In a master with inserted projects that have external links, I want to
display only those cross-project links. I've tried Predecessors
contain
"\\"
and Predecessors contain \\. I can't use Predecessors not equal to
(blank)
because the projects have internal task dependencies and they all
display.
What would be the syntax for not within (a range from 0 to 1000)? I
could
then say Predecessors not equal to (blank) AND Predecessors not within
...

Any ideas? Thanks

 

[Andrew K]

Makes sense. Many thanks.

Hi Andrew,

Glad to know the formula worked and thanks for the feedback.

Without seeing your project file, it is only a guess, but I assume the
reason why you only need the first part of the formula in a master project
is that if a task is an external successor to one task, it is also an
external predecessor to another task in the project. Tasks actually entered
into the master are internal -- all others (from the subproject files) are
external.

Hope this helps.

Julie

Julie,
Your formula works fine. I have two linked projects, and the filter based
on the customized Flag field displays the Predecessor and the Successor.
Now, when I insert both projects into a master parent, I get the same
result
with just the first part :
If(Instr([Predecessors],"\\")<>0,"Yes","No") -
i.e., the Predecessor and Successor tasks both display. Why is that?
Thanks,
AndrewK

Hi Andrew,

Here's a formula I posted awhile ago which may help:

After some *quick* testing, I believe the following formula will work in
a
Flag field:

IIf(Instr([Predecessors],"\")<>0,"Yes",IIf(Instr([Successors],"\")<>0,"Yes","No"))

This will display a Yes if the task has either an external Predecessor or
external Successor. You can then filter looking for only Yes in the flag
field.

Hope this helps. Let us know how you get along.

Julie

In a master with inserted projects that have external links, I want to
display only those cross-project links. I've tried Predecessors
contain
"\\"
and Predecessors contain \\. I can't use Predecessors not equal to
(blank)
because the projects have internal task dependencies and they all
display.
What would be the syntax for not within (a range from 0 to 1000)? I
could
then say Predecessors not equal to (blank) AND Predecessors not within
...

Any ideas? Thanks

 

[JulieS]

You are welcome Andrew and thanks for the feedback.

Julie