Copying cell links
Hi all,
Is it possible that cell links can be copied into another cell or another sheet? Would be great if they could be.
In our business we have workplans which have lines detailing "business opportunities". A number of these opportunities may be consolidated and worked on collectively under one project plan. To update the opportunity status on the workplan, we link each opportunity to various cells on the project plan so all reports update in real time. This often means we have to link the same cells repeatedly across multiple opportunities which can be quite time consuming. It would be great if we could copy the cell link down to other cells on the same sheet.
Thanks,
Sharon
Best Answer
-
You can't copy a cell link, but you can copy a formula with a cross sheet reference.
=INDEX({Reference To Cell}, 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You can't copy a cell link, but you can copy a formula with a cross sheet reference.
=INDEX({Reference To Cell}, 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Brilliant - works perfectly. Thanks so much :)
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives