New answers tagged

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