I got this one that looks hairy to me, but I'm confident you guys can crack it while having fun. The problem: Check of Company exists in the range If not, get t
This code checks if a cell from Q4 to Q20 is green. Now I want to send an email to an emailadress (which is on the same row as the the green marked cell), every
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