Filter logic help

[Troy Lee]

How can I structure a filter to show a specific number. For instance,
I want to filter on my successor tasks. I want all the tasks that show
Task 7 as a successor. However, I don't want to see other successors
that have a 7 in them, like 3fs+7days. Or Task 171. I only want to see
Task 7 even when it is embedded amongst other successor numbers that
contain a 7.

Thanks.

Troy Lee

 

[John]

How can I structure a filter to show a specific number. For instance,
I want to filter on my successor tasks. I want all the tasks that show
Task 7 as a successor. However, I don't want to see other successors
that have a 7 in them, like 3fs+7days. Or Task 171. I only want to see
Task 7 even when it is embedded amongst other successor numbers that
contain a 7.

Thanks.

Troy Lee

Troy,
For your particular example, it would be a whole lot easier to simply
filter on task 7 and look at the Predecessor field. However, I don't
think that's quite what you want. I don't see any way of doing this with
a filter by itself since, as you note, tasks may contain task 7 as one
of several successors. Your best bet is to use VBA to parse the
successor field and then set a flag for the appropriate tasks. A filter
can then be applied based on the flag.

John
Project MVP