How can I link a milestone from one sheet to another sheet?
We have identified a key milestone (e.g. row 38) that we'd like all our other workstream sheets to link to. Reason being whenever that key milestone moves their plans will get automatically updated. Is this possible using a specific formula or function?
Answers
-
Hi @TonyDR,
It sounds like you'd like to link out some important row (milestone) data from a master project sheet to other children projects dependent on that master project.
I assume that dependencies are activated within your projects. If so, you may use cell-linking as long as these criteria are met. If dependencies aren't enabled in your target projects, you'll be able to use cell-linking in all Columns.
I hope that this can be of help, if it isn't, please include some screenshots of your sheets setup hiding any possible sensitive information that you wouldn't like to share.
Cheers!
Julio
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!