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

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