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
So there is a requirement to build tables and charts in google sheets with data in bigquery. The data can be brought in to google sheets using connected sheets.
I'm building a sheets with the following pages: Records Team Records Page: Date Time Where User Pay 01/01/2022 01:40 Warehouse Mike Silva 14,00$ 04/01/2022 07:
I have 2 sets of data that I want to do an outer join on (basically include all data from both sets, with empty cells where data is in one set but not the other
In sheet1 have a column with a list of IDs, each with a set of statuses: ID Apr May Jun 1 Load Load Complete 2 Load Complete NA 3 Load Load
In the previous Article, I asked you for help in calculating the percentages in a given range, now I need further help Link to the previous article how to find