0

How can I get a link to cell in sheets with a formula or appscript? I have a column A with 200 rows and want to get the links of all cells populated in column B

Raserhin
  • 2,516
  • 1
  • 10
  • 14
Dimitar Pavlov
  • 13
  • 5

2 Answers2

1

try:

=ARRAYFORMULA(IF(B:B="",,HYPERLINK("#gid=1734824104&range=B"&ROW(B:B), B:B)))

0

where gid number can be found here:

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124
0

Right click on the first cell (A1) and copy the link to that cell. Then use that link like the example below and drag this down.

=CONCATENATE("https://docs.google.com/spreadsheets/d/a1a1a1a1a1a1/edit#gid=111111&range=A",ROW()))

RemcoE33
  • 1,551
  • 1
  • 4
  • 11