Copy&Paste with relative predecessors

06/28/18 Edited 12/09/19


I have a schedule (created from Project template (aka Gantt chart)) where I have a section which is repeating several times in the schedule. Inside of a section I have dependencies linked using Predecessor field which do not point outside of the section itself. You can imagine this as an agile sprint schedule where tasks are relative to each other inside of the sprint and no task depends on something outside of the sprint.


What I need is to copy & paste several of these sections (sprints) into one schedule, preserving "relative predecessor" inside of the section (sprint). When I do this using the classic copy & paste I always end up with "absolute predecessors" where predecessors of tasks inside a section points to tasks in the section I copied from.


Is there a way how I can copy & paste several sections preserving relative predecessors inside of a section ?


Thanks for any hint, Jan


  • Hi Jan,

    There currently isn't a way to automatically retain predecessor relationships when copying and pasting rows. You'll need to manually recreate them by adding the new row number to the predecessors column.

    When you have a moment, please submit a Product Enhancement Request using the form under Quick links on the right of the Community site to let our Product team know that you'd like to see this feature added to Smartsheet.

  • CJacCJac
    edited 09/03/20

    So, I pay to get LESS functionality than I have with MS Project? Can you explain the benefit I receive with SS?


  • Amanda MerriganAmanda Merrigan ✭✭✭✭✭

    Anyone know if this feature has been updated? Or any work arounds? I'm trying to keep relative predecessors when I copy and paste from a template.

  • Hi everyone! I was able to come up with a workaround for this using Excel. I created a column with #s to match the row number on Smartsheet and another column with a formula linking to the row # the predecessor is. You can then just copy those cells up or below. Once done, you can copy and paste as text, and then copy over to smartsheet.

    Hope that makes sense. I didn't want to spend too much time trying to create steps..

Sign In or Register to comment.