How can I link predecessors from one sheet to another?
A task in sheet A is required to be completed before a task in sheet B can be worked. Is there a good way to do this? Note: I also have a master sheet that is fed from the values in sheet A and B combined. I want to be sure the integrity of that link carries over into our master sheet.
Thanks!
Mandie R
Sr Project Manager
BVOP - CPD | CAPM | CBDA | CSM | CSPO | ECBA | SAFe 6
Answers
-
I would suggest a new row in Sheet B to represent the task from Sheet A and use either a cell link or a formula with cross sheet references to pull over the appropriate data points.
-
I thought of that, but it would duplicate in my master plan, which is a combo of both A and B together so I was hoping there was a different way.
Mandie R
Sr Project Manager
BVOP - CPD | CAPM | CBDA | CSM | CSPO | ECBA | SAFe 6
-
In that case my suggestion would be to have everything in one working master plan and then separate them out using a Report A and a Report B instead of having two working plans and one master report.
-
you can update the feature here:
https://community.smartsheet.com/discussion/103077/cross-sheet-dependencies
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives