🙌🏼Introducing My First Paid Add-On A Story of Motivation Greetings, readers! My name is Max Makhrov, and I am thrilled to share my journey with you as I embark on the creation of my first paid add-on. Last year, I developed a Google Sheets add-on that allowed users to convert Sheet ranges to images. Although it received a poor…

I had stunning success with the Svelte+Material front-end for my Google Sheets sidebar: ↑ Please read about that in the previous story. Now I want to take a rest: Make my code auto-save as I make changes. …

The first result will look like that: The current article shows how to install ingredients for a sidebar in Apps Script, with the front made of Svelte and Google Material. 🧙🏼‍♂️The story begins This is my story because I want to create a beautiful add-on for Google Sheets. …

This is the result: You get subtotal sums for each of the selected columns. Usage in Sheets: =subtotalSums(A2:G31,{1,2},{6,7}) Sample Spreadsheet: https://docs.google.com/spreadsheets/d/16iDOO2otZmPVfpL75dCWR34CeiDgcdcZSNoS7j7hAVE And this is the code: // function test_SubTotals() { // var data = [ // ['a', 'c', 'c', 5, 1], // ['a'…

Few snippets to write logs into Google Sheets. Minimal usage code: function test_write2SpreadsheetLog() { var data = {"hello": "world"}; write2SpreadsheetLog_({data: data}); write2SpreadsheetLog_({data: data, sheetName: 'logs'}); } The code: var C_REMEMBER = { ssId: '1234567990-ABCDEFGHIjKLMNOPQR_StuVWXYZAbcDef' // !!! CHANGE } // function test_write2SpreadsheetLog() { // var data = {"hello": "world"}; //…

This article describes how to use range objects in a custom function. Read it or jump to Sample Spreadsheet and see. Suppose, you make a script for a custom function: /** * @customfunction */ function F(range) { return range; } This will return the range values. The default behavior for…

We all love Google Sheets, right? We know also the pain with IMPORT… functions. They are not stable. This article describes how to create your own ImportRange function and control it. Why you may want it? …

Do this experiment Create a named function: =func(sequence(500)) Name it something like XXX Add a parameter to it: func Use it like this: =XXX(LAMBDA(x,x)) =XXX(LAMBDA(x,AVERAGE(x))) =XXX(LAMBDA(x,INDEX(TEXT(x+TODAY(),"YYY/DD/MM")))) By doing this you pass functions as an argument to the function 🤯

This report shows the use of the new LAMBDA + BYROW function in Google Sheets. Please see this sample file: Lambda + ByRow = 😍ArrayFormula ISDATTE ArrayFormula =BYROW(B2:B10,LAMBDA(r,isdate(r))) IMPORTRANGE ArrayFormula =BYROW(B3:B10,LAMBDA(r, IMPORTRANGE(C1, "'"&r&"'!A1"))) This is a sample from the same Sheet, important note: this method is only for the import of a single cell.