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
We have a few coaches who work for us. When a session is booked, the data including the coach's name and student name is pushed to a master sheet. We have crite
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 a table from "Lead rolling actors" from Wikipedia and I want to add some columns to the table with the dates of birth, years active etc for every actor.
In this shared sheet with multiple lines in one individual cell, I am trying to display the formula result by date by descending date order (ie most recent date
I have this Google sheet where 2 columns are present. Based on a drop down (of list of first column), I have used a vloopup to find corresponding values in seco
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
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
I used the IMPORTXML formula to import values from a website. The formula imports a list of 4 cells in a column. The value of the 3rd cell is a number with a do
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 a script in google sheets with the following function: // Function to get current active sheet-name. function getsheetName(dummy) { return SpreadsheetA
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
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 want to know if there is a formula to extract a complete string containing 'xxx' between two spaces. For example:
I am trying to fetch the attachment data from gmail to google sheets with identifier as subject. The subject format is such as "Disbursement File 2022-05-14" w
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 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