New answers tagged links
2
You need to wrap your formula with an Arrayformula and generate as many rows as column A in Sheet1 has a value in it:
=ARRAYFORMULA(if(len(Sheet1!A2:A),
HYPERLINK("https://docs.google.com/spreadsheets/d/xxxx/edit#gid=xxxx&range=A"&row(A2:A)
, "Sheet1-A" & row(A2:A)),""))
Sheet2:
Sheet1:
Top 50 recent answers are included
