Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Copy links
I use link between sheets a lot.
Sometime I have to link to the same cell a lot of times - but it is not possible to just copy another cell with a link.
Could this be a possibility? It would make my work much easier, since it takes time to make the link to another cell in another sheet.
Thanks.
Comments
-
Hi Ida-- I'm a little unclear on your question, so I'll give answering it a shot and let you know if you're unclear on anything or if I went in completely the wrong direction!
If you copy cells from one sheet, you can right-click on your desired location in another sheet and use Paste Special to paste the cells with a link to the source sheet. If you want to link the same cell from a source sheet to multiple destination sheets, you can copy it once, then paste multiple times in the destination sheet or across multiple destination sheets. Hope that helps!
-
Hi, thank you for your answer.
I tried the "Paste special" but this only copies the format of the text.
I will try to explain more explicit
I have a smartsheet with a lot of drawing numbers - in this smartsheet i update my drawing numbers.
To avoid having to correct the drawing numbers in many different sheets, I link from other sheets to the drawing-number-sheet.
I have a sheet where the same items have different colors - but still the same drawing number.
Now I have to right click, link from cell to other sheet, find the sheet+cell - and I have to do this every time, even though some use the same drawing number.
When I try to copy the drawing number+link, it only copies the number - the link to the other sheet is lost.
I hope this explain my need better
BR Ida
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives