How to include predecessors when copying to another sheet?

Options
Christa Johnson
edited 04/17/24 in Smartsheet Basics

I am trying to copy rows to another sheet but the predecessor relationships don't carry into the new smartsheet when I do. How can I copy rows and retain the predecessors?

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 03/03/21
    Options

    Hi @Christa Johnson

    Hope you are fine, unfortunately, when you copy or move rows between sheets the dependency is not copied, you can play around by exporting the original sheet to Ms Project as XML and import it to the new sheet, or you can copy the values in the Predecessors column and paste it in the new sheet.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • FWPBIDev
    FWPBIDev ✭✭✭
    Options

    Ridiculous. Would be much easier and more user-friendly to include the predecessors and allow users to delete inapplicable ones. The current workflow is absurdly unnecessary. Simple fix. Do it. Geez.

  • yolan
    yolan ✭✭
    Options

    I can't believe this is not fixed yet !

  • George B
    Options

    I was really disappointed to find out that predecessors are lost when copying from one sheet to another. It's totally ruining my plans for a project I'm working on. I have a portfolio sheet that needs to have additional projects added to it over time. My idea was to have a template sheet containing a single project, and then copy and paste that project to the portfolio sheet whenever a new project needs to be added. But losing the predecessors means the automated scheduling is lost.

  • PeterUser
    Options

    It is crazy and unacceptable to rework multiple streams in separate sheets when combining into one. What is the ETA for this enhancement to ensure a seamless experience?

    The more I use Smartsheet, the more I start looking for alternatives for future projects. This is just one of the examples of things that are annoying and not taken care of over the course of time.

  • DoubleR
    Options

    This needs to be fixed - it creates a lot of rework.

  • mtp105
    mtp105 ✭✭
    Options

    I completely agree - very frustrating. Please also add that predecessors do not get deleted if you delete a start date. Sometimes you just need to reset all the project dates. Deleting any date cell removes the predecessor. I can understand somewhat that if you changed a date the predecessor could be assumed not needed, but deleting a date should keep the predecessor intact and be used whenever predecessor dates are entered.

    FYI - PLEASE VOTE on this request for an update for copying rows to another sheet here:

    If I can find a request for keeping predecessors when a date is deleted, I'll add that too.

  • mtp105
    mtp105 ✭✭
    Options

    Per my above comment, I wasn't able to find an existing request for not automatically deleting predecessors, so I created one. PLEASE VOTE for it here:

    https://community.smartsheet.com/discussion/120992/stop-predecessors-from-being-deleted-when-a-date-is-deleted