View Single Post
 
Old 03-23-2014, 02:44 PM
alexRP alexRP is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Mar 2014
Posts: 2
alexRP is on a distinguished road
Default Dependency mapping using custom field - formula help

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
Reply With Quote