Is there an easy way to add the elements of arrays together? Let's say I have 3 arrays. [15,22,35,40] [10,20,12,20] [11,24,14,22] What I want to do is add up
The setBorder() has vertical and horizontal arguments, what are these exactly?
I have the following if statement that removes the first instances of a number followed by the period. However, I am noticing it is missing to catch some of the
Need google app script to make stepwise to an array of numbers taken from a range cell values. Example suppose the taken cell values from A
I really need help. I made a script that inserts values from a table into a Google document. A new document is created for each line. But for some reason, depen
I have a code that someone wrote for me to make import data easier instead of having to write a formula that pulls data from 12 sheets (and is open to error). T
I making a schedule app with pages for each day of the week. There are pages for Mon-Fri. Each page pulls info from their corresponding sheet also labeled Mon-F
I am trying to set up an automated google sheet for crypto assets. In order to get APYs etc I need the ability to get read values from a smart contract IE web3:
I have shared Google sheet in which there is button with function Clear filled rows and Send ( sending the data to other sheet) But when an user enter in the ta
The following code copies a row from one sheet and adds it to the next free row of another sheet. However, one of the cells in the source range contains a hyper
I am trying to create a function that takes form response data and applies it to a template to create a 'completion certificate' with their total scores, then e
I'm trying to build a Macro to erase all the rows that have empty values on column D. Originally, I was using this code that I found: function deleteRows() {
Background I have a function that makes a REST API call using UrlFetchApp in Google Scripts. But the response only returns 2000 records at a time. If there are
I am checking to see if I can use gstatic to scrape favicon from websites. Below will fetch the websites Favicon: https://t2.gstatic.com/faviconV2?client=SOCIAL
I'm trying to extract the time stated on a cell of a sheets file and use it on a function, but I'm struggling to understand what happens: On B2, I've simply inp
i have a sheet that have 5 columns (date , id , name , number ,row number) and i want the fifth column(row number) to be auto filled with the row number when i
Thanks in advance for your help! Our team has a Google Sheet that is used to manage projects. There is a Start Date (Column E) and a **Due Date **(Column F) tha
I find this test for Binance websocket in app script the code in this URL: running websocket in google sheet I want to remove code HTML and run websocket withou
Can we customize the title in alert box for a webapp created using google apps script ? function confirmReserve(text){ document.body.style.cursor = 'auto';
Apologies if this is a somewhat long post - I can further clarify anything here if needed. I basically have an Apps script question in regards