Hyperlink to a specific sheet

google-api, google-sheets, google-sheets-api, hyperlink

Solution

You can use this custom script (Tools > Script Editor) function and connect it with e.g. custom drawing (Insert > Drawing... > Save and Close, then right click on new drawing> Assign Script... > "goToSheet2")

function goToSheet2() {
  goToSheet("Sheet2");
}

function goToSheet(sheetName) {
  var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
  SpreadsheetApp.setActiveSheet(sheet);
}

Update: In the newest version you can select cell and add link (Insert > Link) and select link to specific sheet directly:

Problem

I would like to open a specific sheet of a Google Sheets from a hyperlink in another spreadsheet. I have different links in my master spreadsheet and each should have a hyperlink to the same slave spreadsheet but to a different sheet. I know hyperlink function but it doesn't go to a specific sheet.

Original source