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 information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!