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
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives