Copy and paste link to another sheet?

I use linked reporting extensively so that I don't have to repeat data capture. I often need to copy and paste the same link down a column in a sheet. However, when I copy and paste only the value transfers, not the link out to the data in the external sheet. Is there a way to do this?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Elizabeth Jones

    If the external sheet you're mentioning is also within Smartsheet, and you are looking to create a cell-link between sheets, you can use the Paste Special option when you paste the content to create this link.

    Keep in mind that this only works when you're navigating within the same browser tab (versus pasting between two different tabs).

    Please see this Help Center article on Pasting for more information!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!