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

  • Julio S.
    Julio S. Moderator

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!