I have a google sheet with a table card1 | card2 | card3 | card4 | card5 | card6 | card7 ------+-------+-------+-------+-------+-------+------ set3 | set1 |
I create google form 'on the fly' using data in spreadsheet. Also I install trigger on submit form event. ScriptApp.newTrigger('onSubmit') .forForm(form)
I've been working on this app script trying to automate data from a Google sheet to create events on Google Calendar. I've tried changing the Quotation marks fr
I found code to list the names of all the sheets in Google Sheets (from here): function SheetNames() { // Usage as custom function: =SheetNames( GoogleClock() )
I have a spreadsheet with data in columns A:Z. In column AA is the name of a sheet in the workbook. I'm trying to copy the data in A:Z to th
So I'm attempting to take a sheet from a Google Spreadsheet and save it as a .CSV file just like you can manually do. It is working fairly well, but I've ran in
There is a case where test is given to a certain student. The student can only work with the answer for the test before a given period. Here is the sample case:
I have two sheets that I want to link using a "primary key". At the moment, I have imported from sheet1 into sheet2 some columns using the function =Sheet1!A1
I want create a simple custom sum formula in google Spreadsheets using google app Script. function somaDias(range, days) { var sum = 0; for(i=0; i<d
I would like to know if there's a way to automatically trigger a script every time a specific sheet, inside a worksheet, is selected. Looking around I found the
I'm Thomas and pretty new to appscript. I managed to use it in order to translate cells in a google sheet using DeepL API. I did it thanks to this post : https:
I've just learnt about arrayformula and continue for keeping formulas into new rows, now im trying to get a single string to copy into new rows "N". How can I a
I have a problem with my code. It seems fine but it doesn't work and I really don't know why. I tried everything. I want sync my google excel with my google c
Is that possible to change pivot table totals row location in Google Sheets so that they display directly under the pivot headers? I have browsed the available
Is that possible to change pivot table totals row location in Google Sheets so that they display directly under the pivot headers? I have browsed the available
enter image description here I want to import data from a table within an HTML page. Used IMPORTHTML =IMPORTHTML("https://www.fpi.nsdl.co.in/web/Reports/FPI_For
On sheets, I'm using this formula to sum hours to a specific month from a drop-down menu. =QUERY('Form responses 1'!H2:L, "Select L, Sum(K) WHERE L is not NUL
In google sheet I have 2 ranges of variable length with some data,i.e. column A: aa, ab, ac; and column B: ba, bb, bc. I would like to combine them in one lon
I have a column XXX like this : XXXA Aruin AvolynB Batracia Buna ...I would like to count a cell only if the string in the cell has a length > 1. How to do
The spreadsheet has some cells with cell contents that are separated by commas, or a new line. 123, 876, 456 Column "C" is the column that determines whet