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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!