Formula for cell Link
Hi SS Community,
There is a single cell with a hyperlink in our project metrics (metadata) sheet that we want to display in every cell in a column in another sheet. The idea is that we can create a dynamic report across all of our projects and include the column for the respective hyperlink so it will be right there on any line. Is there a way to fill a whole column with the same cell link and it be done with a column formula etc?
Answers
-
The easiest way to create your cell reference is to start with =JOIN(
This will give you an option to reference another sheet, you can then reference the hyperlink from whatever sheet it is located in. You can then either close the formula with ) or remove the JOIN( leaving you with just ={Reference Sheet}. You can then right click on this cell and convert it to a column formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!