New answers tagged

5

Open menu Tools → Script Editor and paste this code: function getSheetUrl() { var SS = SpreadsheetApp.getActiveSpreadsheet(); var ss = SS.getActiveSheet(); var url = ''; url += SS.getUrl(); url += '#gid='; url += ss.getSheetId(); return url; } Close The Script Editor. And use this formula: =hyperlink(getSheetUrl(),"Link")



Top 50 recent answers are included