none
How to link multiple tasks with a start to start (SS) dependency; MS Project 2013 RRS feed

  • Question

  • Does anybody know how to link multiple tasks with the same dependency?

    In MS Project 2003 this was possible with the agent...

    Any idea?

    Could anybody write a short macro?

    Regards, Max


    • Edited by Maxkuba Thursday, February 7, 2013 1:17 PM Macro
    Thursday, February 7, 2013 12:31 PM

Answers

  • Max --
     
    If you want to link multiple tasks with a Finish-to-Start (FS) dependency, select the block of tasks and then click the Link Tasks button in the Tasks ribbon.  If you want to link a group of tasks to a single predecessor task with an Start-to-Start (SS), Finish-to-Finish (FF), or Start-to-Finish (SF) dependency, try this:
     
    1.  Link only one of the group of tasks with the predecessor task using an FS dependency.
    2.  Drag the split bar to the right to expose the Predecessors column.
     
    In the Predecessors column for the task you linked to the predecessor, you will see the ID number of the predecessor task.
     
    3.  Append either the letters SS, FF, or SF and press the Enter key to the number to change the dependency type.
    4.  Select the same Predecessor cell that you just editing.
    5.  In the lower right corner of the selected cell, click and hold the Fill Handle (little black box) and drag down to to select the cells for the group of tasks you want to link to the predecessor task.
     
    Step #5 above will fill the value from the first Predecessor cell into the same cell for the group of tasks, thus duplicating the dependency on the one predecessor task.  Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, February 7, 2013 1:23 PM
    Moderator

All replies

  • Max --
     
    If you want to link multiple tasks with a Finish-to-Start (FS) dependency, select the block of tasks and then click the Link Tasks button in the Tasks ribbon.  If you want to link a group of tasks to a single predecessor task with an Start-to-Start (SS), Finish-to-Finish (FF), or Start-to-Finish (SF) dependency, try this:
     
    1.  Link only one of the group of tasks with the predecessor task using an FS dependency.
    2.  Drag the split bar to the right to expose the Predecessors column.
     
    In the Predecessors column for the task you linked to the predecessor, you will see the ID number of the predecessor task.
     
    3.  Append either the letters SS, FF, or SF and press the Enter key to the number to change the dependency type.
    4.  Select the same Predecessor cell that you just editing.
    5.  In the lower right corner of the selected cell, click and hold the Fill Handle (little black box) and drag down to to select the cells for the group of tasks you want to link to the predecessor task.
     
    Step #5 above will fill the value from the first Predecessor cell into the same cell for the group of tasks, thus duplicating the dependency on the one predecessor task.  Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, February 7, 2013 1:23 PM
    Moderator
  • The fill handle method would be great if it would work relatively to the upper cell, like in Excel.

    Is there a chance solving this with a macro?

    If you have many tasks to plan this functionality is definitely missing in MS Project 2013.

    Is there any other method? This functionality was there in MS Project 2003, why was it deleted?

    Regards, Max

    Thursday, February 7, 2013 2:01 PM
  • Max --
     
    I suppose you could certainly write a macro to accomplish this.  Or you could use copy and paste to copy the SS dependency to other tasks.  I do not work for Microsoft, however, so I have no insight into why the keep or remove any previous feature.  Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, February 7, 2013 3:04 PM
    Moderator
  • Hi,

    I fail to see what you mean exactly, if not Dale's answer. The fill handle method copies the upper cell down. Isn't that what you want?

    Greetings,

    Thursday, February 7, 2013 4:17 PM
    Moderator
  • It seems like a lot of work for what may be very few tasks but if you really want to set up a sequence of dependencies maybe all of which have the same Lag value you could try doing it through a custom field. Let's suppose that for a string of tasks you want to end up with dependencies like:

            Task   Dependency

    1.  
    2.    1FS+2d
    3.    2FS+2d
    4.    3FS+2d

    etc.

    Using Dale's block linking method, you would get the simple dependencies without the  FS+2d  suffix.

    If you set up a custom text task field with a formula like  [Predecessors]+"FS+2d"  and then copy the contents of your custom field into the predecessors column for the relevant tasks only. Of course you only can do the copy once because the custom field will pick up the new value and you don't want to copy in 3FS+2dFS+2d.

    If you have other dependencies for the same tasks that you want to preserve, you may need to  make sure the dependency with the lag is the last in the list.

    Graham

    Friday, February 8, 2013 1:57 PM