How to create button to go to specific sheet in Google Sheet
#GoogleSheets #ButtonLink
How to create a button to go to a specific sheet in Google Sheet
In this tutorial, I will show you how to create a clickable button in google sheets, that goes directly to a certain sheet. In this video, there are three steps, first, create a button, then write the script, and at the end assign the script with the button.
If you need any kind of button, let me know in the comments.
------------------------------------------------------------------------------------------------------
❤️This is the code❤️
function SwitchToPage10() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Sheet10'), true);
};
and this is the link to the sheet
https://docs.google.com/spreadsheets/...
------------------------------------------------------------------------------------
❤️ Help me pay for my first Camera❤️
https://www.paypal.com/paypalme/elahe...
------------------------------------------------------------------------------------
❤️ Link to the Website❤️
https://sheetfacts.com/
---------------------------------------------------------------------------------------------------------
Subscribe link
/ @techtrickswitheli2023
-------------------------------------------------------------------------------
Related Links and useful playlists
Google sheets playlist
• Google Sheets Tutorials
Google Forms playlist
• Google Form Tutorial