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
I have 2 sheets like the following: Sheet 1 Sheet 2 I want to enter the values from column B on Sheet 2 into column B on Sheet 1. In Sheet 1 the
It is a movie dataset in a simple pivot table where the row fields are by the years the movies were released and for columns I have used "box office revenue" as
I have a script in google sheets with the following function: // Function to get current active sheet-name. function getsheetName(dummy) { return SpreadsheetA
I've started a script that matches an email address in Col D with Gmail and writes the last message date in Col E. I'd like that script to repeat row by row - n