#1
|
|||
|
|||
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:
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 |
#2
|
|||
|
|||
I don't believe you will get there through a custom formula. I think you'll need code (VBA) to loop through the tasks and return the predecessor/successor name and then summary task name.
I am not the person to help - but you may get some assistance through the MS Project forum for programming: http://social.technet.microsoft.com/...ct2010custprog |
#3
|
|||
|
|||
Ok thanks for the quick reply - Its frustrating as this would be quite easy with an Excel type vlookup formula. Im surprised there isnt a function built in to do this anyway. Maybe if i breakdown in to 12 subprojects I can do this?
|
#4
|
|||
|
|||
Again - the issue is that you cannot return predecessor/successor names in a custom field. You can return ID numbers - but not names.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom table of contents referencing a custom field | skaboy607 | Word | 3 | 01-16-2014 06:59 AM |
Microsoft Project Dependency table into an AOA Network Diagram? | acarmich | Project | 1 | 04-22-2013 09:33 AM |
Formula Field using Field Codes | hunter2193 | Word | 3 | 04-05-2013 04:58 AM |
Custom field formula not working at summary task level | abw1987 | Project | 3 | 10-05-2011 07:17 AM |
Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |