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
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
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
I would like to create a script that I can assign to a button in Google Sheets that will copy and paste cell contents in a given column to a cell in that same c
I have a Google Form that contains a simple question that can be answered "Yes" or "No". The responses are being filled in a Google Sheet. How can i identify wh
I need to calculate the percentile using an if condition to calculate it by group of conditions, but Google Sheets doesn't provide PERCENTILEIF function. A nona
I have 3 sheets in a workbook - Sheet1, Sheet2, and Sheet3, every time I change to a Sheet there is a Popup message that will show up. What I
I've made a simple table in a one of many sheets in a google sheet file and I would like a cell range of a sheet to alway appear upper case no mater what user i
I'm working with Python on a movie database on google sheets. I want to build a query searching a list of names and surnames on three columns. I ask the users t