1

To create a custom function use Google Apps Script. This is very similar to writing a JavaScript function. /** * If the arguments are numbers, the sum of will be returned * If one of arguments are strings, they will be concatenated * * @customfunction */ function myCustomFunction(a,b){ return a + b; } Start by reading https://developers.google....


1

I realized that the problem was just that I defined the variable for the columns as "column" but then used a different variable in the code: "col". Simple user error. :) The correct formula is as follows: function onEdit(e) { var column = e.range.getColumn(); var row = e.range.getRow(); if ( column >= 4 && col <= 10 ) { if ( row &...


1

As mentioned in the example at the official site: Sets the active sheet in a spreadsheet, with the option to restore the most recent selection within that sheet. The Google Sheets UI displays the chosen sheet unless the sheet belongs to a different spreadsheet. // Set the first sheet as the active sheet and select the range D4:F4. spreadsheet....


1

Here's how to open multiple urls in different new browser tabs: It creates html script to do the job. Be sure the urls each begin with the protocol (e.g., not just 'www') or google will get confused. The function takes an array of urls. Those can come from anywhere including getValues() where you've got multiple urls on a row in a spreadsheet, or anywhere ...


Only top voted, non community-wiki answers of a minimum length are eligible