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
Beginning from the date on the right corner of the table, I need to automatically fill the days of the calendar. Is it possible to transpose until a given cell
in Google Sheets I'd like to format an area of cells automatically by comparing its date value to another cell. In fact, I have some cells representing a month
With this script I can exclude to insert the same value column in Google Sheet for maximum 100 times. But I am trying to exclude (with if statement) some values
I am trying to extract the Stock Price History Section from Yahoo Finance Statistics page. The following Xpath seems to point to the right section, but the func
I am maintaining a workbook in google sheets where users update their status and date of completion after a certain task is done. A single sheet contains a stat
I have done some digging and I haven't found the solution to my problem. To be honest I don't know the "keywords' to search to find the soluti
I have a google sheet connect to a google form. The form is compiled by team leaders with his members and some informations that are reported in a row by google
I want to know if there is a formula to extract a complete string containing 'xxx' between two spaces. For example:
we currently have a DBT instance that sits over our Google BigQuery data warehouse. Now we've recently been asked to incorporate some data from Google Sheets in
I would like to output "Yes" or "" in column B by using the text version of today's date (e.g. Fri) and finding Fri in column A with values like Tue, Fri, Sun
I am trying to use ArrayFormula to populate row data. I have the following formula that work perfect when I drag down, however I am unable to figure out how I s
I am still fairly new at script writing and am trying a write a script that deletes a row one day after the date which is in column L. The data is in range A133
I have a sample sheet at https://docs.google.com/spreadsheets/d/1Of8JhSnFziFcxSqb4C4eRnZnob1ZuxAnqQOCGdzqvqI/copy. I have a sheet/tab with data: Sheet1. I have
I need to write some functions that involve the same function as the Sheets function MATCH() with parameter 'sort type' set to TRUE or 1, so that a search for 3