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)
Answers
-
You can't copy a cell link, but you can copy a formula with a cross sheet reference.
=INDEX({Reference To Cell}, 1)
-
Brilliant - works perfectly. Thanks so much :)
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives