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
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()))