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
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 422 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!