Copy&Paste with relative predecessors

jkurik52881

Hi,

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

Shaine Greenwood

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.

CJac

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

 

Amanda 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.

PeachyDavee

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..

RKLRpp

Fix this, Smartsheet.

Michael_McKenna

This needs to be updated. Scheduling functionality is severely limited without preserving relative relationships.

Jason C

I'll add to what is probably a growing chorus...please fix!!

Kayla Q

Gimme!

yolan

Please fix this !!

PassGas247

BUMP. Please fix

doug.reynolds

Copying & pasting recurring patterns of tasks (sections/sprints/locations/etc.) without a relative reference to predecessors is a royal PITA. My project has repeating tasks in each of 240 locations. The tasks relate to each other, but not outside each location. The changes create an enormous pile of work, and if something needs to change…. ugh.

rbarlotti

Please fix this