I cannot work this out: In Google sheet, I'm trying to unpivot a wide and long table by using this formula: =ARRAYFORMULA((SPLIT(FLATTEN(sheet1!$J$3:$J&"//"
I have a Spreadsheet with about 3000 rows which are grouped by order number. I'm trying to build an macro to: remove all groups multisort all rows recreate gr
I want to retrieve the name of a cell having his range. this is the range : var rangeOfCell = sheet.getRange(100,5); I want to know how to get his native(A1, A
I try to query from other sheet using vlookup() or something similar. I want to count how many array it will produce. How can i find the length of the output or
Simple contact web form. I cannot figure out why it does not work as intended. On open sets up a menu, allows me to select a modal, non-modal or sidebar for for
Say that I have a dropdown list based on a column that has "cat, dog and rat" on it, and some lines select the option rat on the dropdown. After that I remove "
I am trying to do something and I am almost there but I have been scratching my head on a 'length' issue for quite some time now. What I want to do : Get data f
I am very new to Google Script. I have some pdf files in a folder on Google Drive and I am trying to convert pdf to google doc and extract specific text. PDF ha
I want to automate a report where we want to add 200 rows of data into a spreadsheet, the data in these 200 rows comes from Google Analytics with each row havin
I'm working in a google spreadsheet with multiple sheets. This is a situation where I can mess around in a sheet (I call it Sandbox) that I make but can't do an
I have been trying to translate text from HTML code. Here is an example: var s = '<span>X stopped the</span><icon></icon><subject>
I try to publish an Editor Add-on for Google Sheet into the workspace marketplace. But I'm struck on the review. With this message : The App doesn’t meet
I have a spreadsheet that I would like to create an app script function to clear data/set values from certain cells. It also needs to work up to the last row, a
So there is a requirement to build tables and charts in google sheets with data in bigquery. The data can be brought in to google sheets using connected sheets.
I'm building a sheets with the following pages: Records Team Records Page: Date Time Where User Pay 01/01/2022 01:40 Warehouse Mike Silva 14,00$ 04/01/2022 07:
I have a google sheet like this I Need to make a google appscript webapp like below with the above sheet. only the price field need to be editable. When it is
I have 2 sets of data that I want to do an outer join on (basically include all data from both sets, with empty cells where data is in one set but not the other
We have scales for which we upload data based on a Google sheet that we maintain. The Google Sheet translates the data into the correct configuration and we exp
I want to list all videos of a YouTube channel in Google Sheets and see statistics if possible. How to achieve this with Google Apps Script?
How can one create an Apps Script function to sum only numbers given a string. I've been able to do this using this regular formula within Google Sheets: =SUM(S