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
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives