Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2014, 02:44 PM
alexRP alexRP is offline Dependency mapping using custom field - formula help Windows 7 32bit Dependency mapping using custom field - formula help Office 2010 32bit
Novice
Dependency mapping using custom field - formula help
 
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
  #2  
Old 03-23-2014, 02:52 PM
JulieS JulieS is offline Dependency mapping using custom field - formula help Windows 7 64bit Dependency mapping using custom field - formula help Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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
Reply With Quote
  #3  
Old 03-23-2014, 02:55 PM
alexRP alexRP is offline Dependency mapping using custom field - formula help Windows 7 32bit Dependency mapping using custom field - formula help Office 2010 32bit
Novice
Dependency mapping using custom field - formula help
 
Join Date: Mar 2014
Posts: 2
alexRP is on a distinguished road
Default

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?
Reply With Quote
  #4  
Old 03-24-2014, 08:03 AM
JulieS JulieS is offline Dependency mapping using custom field - formula help Windows 7 64bit Dependency mapping using custom field - formula help Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Again - the issue is that you cannot return predecessor/successor names in a custom field. You can return ID numbers - but not names.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Dependency mapping using custom field - formula help 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
Dependency mapping using custom field - formula help 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft