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
I am looking for some help with a SUMIFS formula. I am trying calculate the revenue between dates for a coupon code, where the coupon code sales are in a separa
Background Information I am trying to setup a 1st, 2nd and 3rd rank/scoring system on Google Sheets. The sheet is setup by row and once a week a new row is adde
I have an extract from a description off a webpage which contains multiple links to other pages the whole string is in a single cell. The string below is along
I've created a quote form, and in one cell (C6:H9) I enter the address with the city name. In another cell (C31:F31), I have a drop down list with different cit
I´m trying to take information from a website to googlesheets and I tried with importxml and importhtml, but it´s not working. https://www.fpf.pt/pt
I have a grid which lists the Period (Start - End), and a list of Downtimes. The downtimes are then sorted (to ensure chronological order based on the start tim
I need to extract each word (phrase) within a cell in google sheets and put each one under the other in a column (row for each one). I have a regex code that w
I got responses from Google form into Google Spreadsheet. I want to filter out the "Weekend" and "Workday". For the "Weekend" days, I only want to select the co
Google Sheets has the following IF Function: IF(logical_expression, value_if_true, value_if_false) Is it possible to have multiple 'values_if_true' where the fo
How to RegexReplace but only for number. I tried this formula, but it didn't go as I expected: =REGEXREPLACE(A2, ":<BR CLASS="""">[0-9]", ": [0-9]") Th
I cannot work this out: In Google sheet, I'm trying to unpivot a wide and long table by using this formula: =ARRAYFORMULA((SPLIT(FLATTEN(sheet1!$J$3:$J&"//"
I want to retrieve the name of a cell having his range. this is the range : var rangeOfCell = sheet.getRange(100,5); I want to know how to get his native(A1, A
I'm working in a google spreadsheet with multiple sheets. This is a situation where I can mess around in a sheet (I call it Sandbox) that I make but can't do an