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
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives