Formula for cell Link

Gianni

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?

JamesB

@Gianni

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.