google sheets

Hi, I am currently working with Google sheets on my phone so restricted with how to show what I am after. I want L4 to reference Q3 and return a value from the range FE25:FF63 Basically the values in column FF increase but there’s no pattern to the increase in the respective FE row is the...

Hi Everyone! I am trying to create a spreadsheet to better track equipment as well as personnel at work. The basic idea is managers at different sites submit daily a check list at that info is added to a sheet similar to my sample...

Hi, I'm trying to create a new rota for my workplace [Google Sheets – image below- Column D needs to be a total number of nonblank cells, but only if they're not any of SICK, HOL, SAB, OFF, MAT, PAT, R/O. (So in that image, it would just be 4). I'm currently using...

Hi, I am looking for a formula that looks between two date ranges (that can be adjusted in cell B10 and B11 of the below) and return the COUNT of data within those ranges. If anyone can help with this it'd be much appreciated. Link to the Google Sheet here: Google Sheets: Sign-in Thanks Ryan

I have the below data and want to see how I can achieve the last column, in google sheets. I was given an excel solution in a different thread but unfortuunatelt the AGGREGATE function is non existent in google sheets. The excel solution given is: =IF(A2=A1,C1,SUBSTITUTE(B2&" TO...

Hi all, Wondering if you can help, although I may have bitten off more than I can chew with this haha. Basically I am creating a grocery list generator (or attempting to) where on one sheet is a list of recipes and their ingredients and optional extra ingredients, with check boxes (see image)...

I have a spreadsheet on Google Sheets with essentially 2 tables. The below is an example of what it looks like, but my data is more complex and with a wider range. In the first set of data or table, in the rows down I have items, and in the columns across I have categories. Each Item (row) has...

Hi, I have a spreadsheet in Google Sheets which has multiple sheets. All the different sheets represent different categories - the first rows of all the sheets is the same. Is there a way to auto-populate and consolidate all the sheets so that they are all in one master sheet? The first two...

Hello, Actually I have to update a master google excel sheet daily with numeric values. There are thousands of names across which value to be updated daily by datewise (new date in new column). Daily I get names with num values which eventually to be entered in their respective cell of a new...

Hi, me again as you guys are really helpful. My next question that I can't seem to figure out is there a way to auto populate a sheet every time you add a new entry to a different sheet. This is the scenario: 5 sheets that I enter information into based on their filters. These sheets will have...

Hello! I am trying to find a way to delete certain cells based off a check box in another. For example if H3 (which has a checkbox) is marked as true, then I would like B3,C3,E3,F3,G3, and I3 to have their contents cleared. Is this possible with a formula or script? I have attached a photo...

Hello, Our warehouse ships out a full truckload every day and in each truckload, we will have x amount of units. I want to create a spreadsheet that will keep track of how many trucks we are doing per week and units and give me a nice breakdown of how well we are doing per week, month, quarter...

How can I have a named range populate the above cell relative to the dropdown list, based on the dropdown lists selection? Say I have a dropdown list in D4 and the user selects the option 'apparel'. How can I make it so that D3 auto-populates with the named range apparel? The named range is 4...

Hello, I have a sheet of fictional data here: duplicates. Below is a screenshot for convenience. I'd like to list, in the duplicate column, duplicates of values in the id column, with one condition: that the corresponding row in the complete column must contain a 1, not a 0. Furthermore, I'd...

I'm trying to use a Vlookup function, but I want it to have multiple possible outputs. All of the other help I've seen seems to just want to outputs, an error, and a correct. I'm trying for three different outputs. I've tried searching for help multiple different ways, but I can't seem to find...

Hello everyone, I have a Google Sheet that I need to apply a conditional format to using a formula. If Cell D3 and E3 are blank and cell G3 is greater than 7, then I need cell B3 to highlight yellow. I have attached a screen shot of an example. Any help is much appreciated!

I have a google sheet which tracks various categories of values, and these categories get summed up. So, the final result is a number. Sample data: "E(12), P-6, TW=4, 5" => The key values are: 12+6+4+5, formula should return 27 "2E, 2P, 6TW, 2O" => The key values are: 2+2+6+2, formula...

The IMPORTXML formula for Google Sheets is "=IMPORTXML(Url, xpath_query)". For example webpage Amazing Spider-Man #365 Value - GoCollect, I've been trying to extract the data under "Preview Grades", specifically the FMV data per grade. I don't know what I'm doing wrong, but I can't figure out...

I am trying to understand what a previous user is attempting to do in a google sheet template. I can't seem to wrap my head around the multiple filter functions in in cell. The formula is below, happy to provide any context as needed. ={filter('Report 696'!C2:C,'Report...