merging multiple sheets into one with dependencies reserved

Schedules for two different part of the same project were created on two separate sheet. I would like to merge them into one, with dependencies and relationship preserved. I have tried the below already with no success

  1. copy/move
  2. create a report

Any help is appreciated.


Thanks!

Answers

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    Linda;

    Are you referring to SmartSheet predecessors? When you try to combine the sheets, do you lose the row references that ties the rows together?

    My brute force solution to this was based on matching row numbers AND copying information across with Ctrl-C and Ctrl-V NOT with Copy to Another Sheet...

    *** If the row number the data comes from matches the row number the data is pasted into your predecessors should match and activate.

    Let me know if that works.

    Dale