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
- copy/move
- create a report
Any help is appreciated.
Thanks!
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives