I have an already functioning simple query function that pulls from several different sheets. I was looking into whether I could add something to the function to append a link to a specific cell of each row.

I have a data table in Google Sheet and I wanted to create a formula to display a concatenated list of specific items from the table in 1 cell only. My spreadsheet sample shows the formula I am using in cell F1.

I’m working on a calendar in google sheets and mapping different shipping scenarios. I want one cell to surface the day of the week something is delivered by looking for “Box Delivery” in the range and then checking 1 OR 2 rows above for the day of the week (as it could be in either). I have a formula that is working to check one row above but it isn’t working for two rows above.

I have a master sheet with data and another table that filters values ​​through the query function. In the table with the query values ​​there is a column that is completed manually, that is, values ​​are added does not depend on the query. The problem is that when you refresh the data in the master sheet and add new rows, the query executes and the values ​​are moved, moving values ​​to other positions.

Spreedsheet example I am attempting to apply the formula in D1 of TeamRanks,

I am struggling with the syntax of the following equation:

I get #NUM! error if I edit the cells in row 2 and 3. Error will be in the corresponding row below that certain edited cell.

I’m trying to put together a sheet that summarizes data from ~70 other sheets, which are all titled by year. What I’m looking to do is find a way where I don’t have to hard-code each sheet and can “drag down” the formula and get the other sheets’ data.

I have a problem with my google sheet. I hope someone can help me or point me in the right direction.
I auto create a table with following structure:

I am trying to create a tracking sheet for our local high school’s target shooting team. My Google sheet will calculate the the average of all rounds shot. However, I am trying to write a formula that will only take the average from the last 10 entries while omitting any cells with a 0. Now Column AB5:AB42 will calculate the average for each row. In cell B3 it will calculate the average for all rounds. I would like for cell B3 to only calculate the last 10 entries while ignoring the zeros on the sheet. Any ideas are greatly appreciated.