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:
- If there is a predecessor that goes from one workstream to another
- If there is a successor that goes from one workstream to another
- 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