Hi,



I have a large project with 12 workstreams at outline level 1.

What I want to do is have a field or fields which show:

1. If there is a predecessor that goes from one workstream to another
2. If there is a successor that goes from one workstream to another
3. The name of the workstream that the presecessor / sucessor.

e.g. if workstream 1 (PW01) has a task with a successor in workstream PW04, I want a column that says "OUTWARD DEPENDENCY" then a second column that says "TO PW04". I have a column for each task which says its workstream number.


How can I make a formula that shows to which workstreams the dependencies go? I am specifically interested in ones that go across workstreams, but equally to show for all successors would be good.

Let me know if you can help