I have the table bellow where each column from J to M are prices for a certain activities. Column I is the Size I want to create a new table where automatically
I can use the Power Query tool to import data from Google Sheets easily, if the sheet is publicly available via a link. I just choose "Data from Web" and use th
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 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
We currently have a fixed report data that we can only manipulate after download and to simplify, it looks like this: raw report data extracted to google sheets
Im trying to figure out wallet balances on google sheets with the =IMPORTXML function I have a list of wallet addresses in column A and trying to get Wallet Ba
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 want to replace 3 caracters in one string =ARRAYFORMULA({REGEXREPLACE(A5,"c","a"); REGEXREPLACE(A5,"d","x");REGEXREPLACE(A5,"v","y")}) is possible? I want to
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
Google Sheets I have a sheet with two cells (B2 and B3) and I added drop downs to the cells, Cell B2 has Yes and No as its values(drop downs) and B3 has Yes and
I am importing data from 4 sources, their format is: | C | D | E | F | G | H | | 31.03.2022 | * | -60 000 | * | * | Prep
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 have this problem , in a google sheet's cell I have put inside this formula: =IF(OR(AND(F21>"01/05/2022";F21<"31/05/2022");AND(G21=2;));$J$4;"errore");
so I have 5 separate google sheets, each one with the same title and format enter image description here. There are 8000-10000 rows each so far, as it's a daily
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
From what I have read, it appears that INDIRECT() does not function with ARRAYFORMULA(), however have seen some custom workaround solutions fo