If i mark and select 5 rows in google sheet. I want to retrieve an array of retrieved rows. Particully column (0). function selectRow() { var sheet = Spreadsh
Im not an expert at excel/sheets. I wanted to make a dynamic function that would stop user error by doing all of the work. The function basically uses regex to
I am using Google Apps Script to check and re-format date data from some Google Sheets. But the problem is the result shows the times for the user who run the c
I have a sheet with a table with content in the range B6:Y1000. I would like a script that would delete all rows if column C-D-E-F-G are empty
As of a couple of weeks now, I'm getting a "Service error: Spreadsheets" error when running a script in Google Sheets. Before that, it was working fine. It's su
I have a block of html text from which I need to extract the link texts. The HTML code is <li><span class="jkey-title">Job Field</span> <sp
I need some help regarding Google sheets and SUMIF instruction. I have a table where I collect some inputs from a form. I contains a date, name and value. Now I
I need some help regarding Google sheets and SUMIF instruction. I have a table where I collect some inputs from a form. I contains a date, name and value. Now I
so I have a spreadsheet with name, email and phone number now I'm using another service to verify those emails but the problem is that the software is returning
How can I highlight Partial matches in a single column of google sheets? some entries are the same but they have slight misspellings or some are in lowercase. H
I have this table with data below and need help because I don't know which formula can I use to convert the table into the desired one. I don'
I have a google sheets document that has a main sheet which will have columns x y and z and subsequent sheets 1, 2, and 3 that will each also have columns x y a
I am trying to write a formula that will take a set of columns and pair them into separate rows with a comma-delimited list. In SQL, I would do this with a left
I tried to take a code and adapt it to my needs but without success as I am new in script. This code allows to generate a google map with markers on several add
Started getting below error randomly. while same code works fine if I stop my service and sun again. but after 1 days or two its start giving this error. I have
I need help, I'm using an onEdit function to implement data validation based on a sheet. It is working fine when I use it alone. I can choose a type in Colonne
I keep getting Authorization errors when sending a POST request from my React/Ruby app. I'm getting different errors depending on what OOB_URI I'm using. If I u
I already have a script that kind of making what I want, but I have a small issue with it, it's that it copy all the sheet with everything instead for me, I wan
I use this formula to get the data: importXML("https://at.fuelo.net/fuel/type/gasoline?lang=en"; "//table[@class=('table')]//tr") How to get price without a si
I have some strings inside Google Sheets, containing simple arithmetic expressions: Is there a way to evaluate these expressions without the need for writing a