How can I link predecessors from one sheet to another?

mroehl

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!

Paul Newcome

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.

mroehl

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.

Paul Newcome

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.

Harry Luk

you can update the feature here:

https://community.smartsheet.com/discussion/103077/cross-sheet-dependencies