google sheets

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...

Hello, I need to make a spreadsheet but I'm still new to Google Sheets. I would like how it would be to make a spreadsheet that: from an initial date, put the number of days you want, then show the end date (except for the holidays I put and also weekends). At the end I would like you to show...

I attached a file with the example of my original document. How can I use this addon to count all of the working hours?

Hello, Just wondering if any knows if / how this can be done in Google Sheets. 10 colums of data with 1,000 rows on a Google Sheets Document What forumula can I use to automatically insert one or more blank rows after every 100 data filled rows to break up the large block of data? Is there a...

Hi, I have a timesheet on google sheets where a timestamp is generated in a cell when someone presses a picture of a clock on the sheet. Is it possible to lock cells so that it rejects all input that is not generated through the timestamp script but still allow specific authorized users full...

Hi guys! I have a column that I need to color with conditional formatting based on two different criteria. I am using the following formula in the conditional formatting pain and it does work: =AND(AC2="Yes", AK2=INDIRECT("Partners!B6")) The issue is I need the range of Partners!B6:B not just...

I am trying to use countifs function in google sheets to count colored cells in one column, but only if the colored cell meets the value I set in a separate column in the same row. In my head, the formula would be something like: =Countifs(I:I, "Tuesday", P:P, "light green") I am already using...

Hi, I’m trying to average the total minutes of the first N -- in this case, 3 in lieu of N -- movies watched by a client. Please see my sheet: docs.google.com/spreadsheets/d/1oTwnB5u7y4KqAwamvjsEats3JiTPpYhEkOqUvOzEkDE In column A, you can see the extracted numbers from the minutes texts so...

Hi everyone, I'm using the Filter function and it's returning several values. I only need one of those value. Let's say the first one. Is there a way to do that? Thank you

Hi Everyone, I have been working on a table for several days. I need 3 formulas. There are a several different functions and several different alternatives. I hope someone can help me!! In the table here, I need to find the conflicts and offer alternatives. In Conflict Formula for column G =...

Hi all, I'm working from Google Sheets, trying to mail merge the address... I'm wondering if there is anyway to take JUST the Street Address from Column D and put it in Column E below. We got data that had the whole address sans commas. We already have matching data for F through H (City...

I saw this posting on stack overflow: How to get Historical Price from a specific time? The second answer had this: =ARRAYFORMULA(QUERY(GOOGLEFINANCE("GOOG","price","12/22/2020",30,1), "SELECT * WHERE Col1 matches '.* 13:.*|.* 16:.*'", 0)) and this...

Hi All, I'm trying to figure out how to make it so that when I click a button that I created in Google Sheets, it takes me to the cell I told it to (via the code below) and brings that cell to the top of my sheet in terms of viewing. I don't know code, but I found the code below online for the...

I'm trying to find the average number of the maximum speed of 1000+ entries. I'm also trying to find the maximum distance travelled, in a different column, which also contains numbers & letters. Obviously going through 1000 separate cells isn't feasible, and I cannot seem to find the correct...

Hi I am very new to using the script editor, but i need help getting a background color in column 4 based on the rgb values in columns A(r) B(g) and C(b). I would need it to change when those values change. is there any way to do this? here's a screenshot of what my sheets doc looks like.

My Google sheet can be referenced here. On the 2021 Openers tab, I need to create a formula that will allow me to count the total amount of leads associated with a specific person within a specific month, referencing the data on the 2021 Lead Data tab. Formula criteria to consider: The Leads...

In Google Sheets I have a column that checks another two column's and calculates the difference. I already have it conditionally formatting to be green or red depending on the difference being less than or equal to 0, and greater than 0 respectively, but I specifically want to have it display...