I want to add in some additional information to a sheet that is populated by Google Forms from another tab in the same worksheet. I want to have a formula which looks up a value based on multiple ...

I am doing a tiny home store overview lists. At the movement sheet I want to sum ONLY the same and previous rows but never mix the results with the future row values. As I use mostly ARRAYFORMULAs I ...

I originally tried a sumifs formula but that did not work so came up with this work around. =ARRAYFORMULA(SUM(IF(IMPORTRANGE($S$3,"Sheet1!A2:A1009")=$G$3, (IF(IMPORTRANGE($S$3,"Sheet1!...

I have a single column that contains mixed data (strings, numbers, sometimes blanks) and from time to time, there are marker rows that delimit blocks of data. What I would like to do is: Start ...

I have a dataset in Google Sheets like this: Purchase Date Price 9/24/2023 $49.00 10/25/2023 $29.00 1/4/2024 $29.00 1/8/2024 $39.00 1/31/2024 $39.00 2/21/2024 $29.00 3/13/2024 $49.00 3/13/2024 $39.00 ...

I have a column of strings of the format "#.# km, # mins" in column F. (The spaces are literal. # is for numeric. The number of #s is not literal.) For example, F 21.2 km, 27 mins I ...

I having some difficulty solving the issue below. Would appreciate some help with this. My Google Spreadsheet has two tabs. Product_Database and Data_Sample. In Data_Sample, I have a column of ...

I've got a spreadsheet listing items with a possible child-parent relation (no grand children, children never come before their parent, but children of different parents can be mixed), and I'd like to ...

I have a spreadsheet with multiple tabs in which I would like to filter all existing rows in one sheet (the Source sheet) based on a set of comma-separated tags. I have a dropdown at the top of the ...

I'm trying to write a formula that determines the fiscal year period based on a July 1 start date. I would like quarter intervals for each period to signify which week of the month for the period as ...

I live in a country, where by law, certain holidays are not allowed to fall on a weekend. If they do, they need to be delayed to fall on the first available working day. For example, the holiday of ...

I’ve run into this issue a few times now and can’t seem to figure it out. Is there a way to return multiple values in one cell (i.e. cell 2) for multiple lookup criteria in another cell (i.e. cell 1) ...

I made a sheet to use as a test checker. Each test covers different domains. I can count all correct answers using SUMPRODUCT, but when I sort items by domain, the formula stops working. What formula ...

I have a spreadsheet with multiple tabs. On one, I have where players indicate if they'll be attending a game on a particular date, and on the other I want to populate a list of who has rsvp'd "...

I have a Sheet which basically adds name and address info from a membership list to a list of bank payments. LINK TO EXAMPLE SHEET It uses an Xlookup (in Column G) to compare the Bank Account Name (...