Linking Predecessors to Other Sheets

heidi_flores86196 · 04/23/20

Am I able to link predecessors to other sheets that are related to my project? Thank you for sharing best practices on how to do this.

Genevieve P. · 04/23/20

Hi Heidi,

No; if you have dependencies enabled on your Project Sheet, you will not be able to cell-link Predecessors to another sheet. Please see this Help Center article (here) for types of cells that can't be linked across sheets.

You could copy the data from that row over, but it wouldn't update as the other sheet updates. Or you could create a Report to show specific rows from each sheet, but the rows wouldn't be related to each other (although you could see them all together).

It would be useful to know a bit more about your projects and how they are linked in order to help come up with some other ideas or best practices. Any screen captures you could post would help, too, but please block out sensitive data.

Cheers,

Genevieve

Genevieve P. · 04/23/20

Hi Heidi,

No; if you have dependencies enabled on your Project Sheet, you will not be able to cell-link Predecessors to another sheet. Please see this Help Center article (here) for types of cells that can't be linked across sheets.

You could copy the data from that row over, but it wouldn't update as the other sheet updates. Or you could create a Report to show specific rows from each sheet, but the rows wouldn't be related to each other (although you could see them all together).

It would be useful to know a bit more about your projects and how they are linked in order to help come up with some other ideas or best practices. Any screen captures you could post would help, too, but please block out sensitive data.

Cheers,

Genevieve

ZCHRYMN · 01/31/22

@Genevieve P. I am working with a client. Each functional leader owns their own workstream (e.g. finance, IT, sales, etc.) under a large project and each leader has a sheet dedicated for their management. In order to reach a milestone, however, sometimes IT + Finance or Finance + Sales must work together. It would great if the predecessors could reference another sheet. I can get a bit more specific if we could chat. Would love to hear of any work arounds.

Genevieve P. · 02/01/22

Hi @ZCHRYMN

What about creating a Report to bring together two sheets when you know certain action items have to be completed in each separate Workstream? You won't be able to have the rows dependent across sheets, but this would allow you to visualize the combined tasks needed to reach an end goal in Gantt view.

Cheers,

Genevieve

Callum Heron · 05/15/22

Would it be feasible to implement this as a feature? It would be extremely useful since tasks are very often dependent on tasks managed by other teams.

KenW · 05/17/22

Agree that it would be extremely useful to enable cross-sheet predecessors to integrate diverse and interdependent workstreams owned by different resources. Thanks.

ebford · 06/29/22

Bump. This would be incredibly helpful. Please implement.

Daniel Payne · 09/26/22

Bump

amohan · 11/21/22

This would be an excellent feature to add. Dependency linked to other sheets.

BdH · 01/30/23

This functionality would increase Smartsheet value for Project Portfolio Management greatly,...

Jason C · 02/20/23

Hello,

Just adding to the chorus here. This would be a fantastic enhancement.

Amy B · 04/26/23

This would also be helpful for archiving sprints/stories to another sheet while still maintaining the predecessor link for future stories.

Carolyn · 05/19/23

I agree that this would be beneficial and my team would find this helpful in future updates.

Matt Springer · 08/15/23

This function would be massively useful

markog · 11/06/23

I started to try out SmartSheet for the company where I am working at. I had big hopes that this feature would be available. Now, unfortunately, I have to read that it doesn't work. That's a great pity. I hope it will be available in the near future!

Harry Luk · 11/13/23

bump

need this feature, is there a feature request where we can upvote?

Formulas and Functions

Formulas and Functions

Linking Predecessors to Other Sheets

Best Answer

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Created Date of Row Copied from Another Sheet

Need to update dates to Q1_2025, Q2_2025, Q3_2025, Q4_2025

Writing a reference formula with multiple IF/AND situations