Questions tagged [google-sheets]

For questions about Google's web application to create and edit spreadsheets on a web browser or app. Don't use it for the Google Drive Excel files editor. Please consider adding a demo spreadsheet to your question; this will greatly increase the chance that you get a satisfactory answer.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 views

Google Sheets - SUM the max value in rows where there is a unique value in a group

I'm trying to have a cell sum the maximum values in column C for each unique instance of A where B matches cell A1 on my sheet. A B C Pie Apple 3 Tart Apple 2 Pie Cherry 1 Pie Apple 5 Tart ...
user avatar
  • 1
-1 votes
0 answers
8 views

Calculating open backlog at a point in time

I'm trying to work out how many tickets were opened on our Service Desk at a point in time. We have open and closed dates, so I'm trying to use Google Sheets or Excel to create a blank calendar and ...
user avatar
-1 votes
0 answers
5 views

Return the URL from google search within Google Sheets

Hey I'm trying to return the first search result from google on google sheets, But I have had no luck. I tried recording macros, which also failed
user avatar
-2 votes
0 answers
9 views

RIF RIGA -5 GOOGLE SHEET

RIF RIGA -5 GOOGLE SHEET . hello to all, in the formula located in cell e3 of the sheet "Foglio2", there is ref row -5, which I understood what it is for, but in which cases should this -5 ...
user avatar
-1 votes
0 answers
10 views

Average the smallest 3 values of the last 5 values, excluding blank cells

I'm trying to average the smallest 3 values of the last 5 valves, excluding blank cells, in a row. I have a working Excel formula, but I'm not savvy with Sheets yet. Here is a screen shot of my Excel ...
user avatar
-1 votes
1 answer
11 views

How to conditionally format cells based on presence of strikethrough text?

I am trying to apply conditional formatting to the cells in this example spreadsheet. Currently, I have a list of clients that occasionally report issues in the corresponding month columns. Once the ...
user avatar
  • 1
0 votes
0 answers
21 views

google sheets import and sum data from multiple sheets

I'm at a loss as to do what I'm wanting. Main Sheet: TA 30 TB 50 TC 12 Sheet TA: C .45 D .36 E .12 Sheet TB: C .44 G .03 R .15 Sheet TC: C .10 D .06 Z .09 What i want to do is foreach ...
user avatar
0 votes
3 answers
19 views

Find totals for each category based on categorization

I'm using numbers to categorize items in a list, each with a $ amount. Column A has a number, 1-15, depending on the item in column B. Column C has the cost of the item in column B. I want to find the ...
user avatar
0 votes
1 answer
10 views

How to extract multiple email addresses in a Google doc?

This is the content of the cell and several like this. I need to extract only the email addresses. This is the function that I have so far: =arrayformula(regexextract(query(split( transpose(split(A1, ...
user avatar
0 votes
1 answer
8 views

Google Sheets: formula to match and find column header value if there is a tick/cell is not blank in a row

I'm wondering if there's a formula I can use in the following situation. I have a spreadsheet on Google Sheets with two data sets. The first data set shows the rows down as Items for example, and the ...
user avatar
  • 5
0 votes
0 answers
12 views

How to filter and sort according to a preset order for a Query in Google Sheets

In Google Sheets, I'm using a query to pull all my data from different tabs into one master sheet. And now I'm wondering how to sort the data according to a preset order. The order I want to sort to ...
user avatar
  • 5
0 votes
1 answer
34 views

How can i protect app script code from the editor?

I have a spreadsheet, and I have shared it with 50 people for the editor role. I have written some js codes in app script but unfortunately, someone removed my code and the spreadsheet has been ...
user avatar
  • 7
0 votes
0 answers
9 views

How do I perform a VLOOKUP to the left without explicitly naming the left column range in Google Sheets?

I have an array of data that I want to look up a specific phrase from. Once the phrase is found I would like to output the value or phrase of the cell to the direct left of the cell that’s found. I ...
user avatar
0 votes
1 answer
23 views

Change text colour based on a condition in Google Sheets

I do NOT mean the whole text of a cell, but specific words within the same cell only. For example, in the following example you can see a list of words. As "bbb ccc" is in that list, only ...
user avatar
  • 345
0 votes
1 answer
11 views

How to do extract multiple email addresses in a Google doc? [closed]

[{"responseStatus":"accepted","email":"XXXX@XXXX.com"},{"organizer":true,"email":"XXX@XXX.com","responseStatus":"...
user avatar
0 votes
0 answers
21 views

Number of Cells which have a specific text, but where the row also has another specific text

There are some WoW terms in this post, will clarify if requested. I'm making a spreadsheet in google sheets for my wow guild where we will be able to input our class, spec and if it is an alt or not. ...
user avatar
0 votes
1 answer
30 views
+50

Google Sheets LOOKUP last available value from another sheet

I have an excel document with the LOOKUP formula which grabs the last entered date from another sheet. From below, you can see the date for 'Person One" is also the last date entry on the second ...
user avatar
  • 63
0 votes
2 answers
14 views

Array Count by Week in Google Sheets

I am trying to create a running column array that counts the number of occurrences by person by week. It can't be a pivot table or separate array table but a calculated column that updates beside the ...
user avatar
  • 101
0 votes
0 answers
14 views

Google Sheets Conditional Formatting, set one cell as true if to other cells are true

I have three columns. G is if the product has a women's picture. H is if the product has a unisex product. S is if we need to send that product on a photoshoot. I want to make a condition that says ...
user avatar
0 votes
1 answer
30 views

How do I relative the cell value only?

For example I have a sheet and there is a col with cell-like A2 and A2 has a hyperlink. A2 value is 'Apple' and the hyperlink is 'stackexchange.com'. When I am trying to use importrange formula with ...
user avatar
  • 7
0 votes
1 answer
7 views

Auto Replace feature in google sheets?

I'm trying to make a column in google sheets that shows whether someone paid cash or card. I currently have functions in place to make the colors change based on if "cash" or "card"...
user avatar
0 votes
1 answer
30 views

How to order column groups by a cell's value

I have a spreadsheet of multiple datasets in columns. I checked some documentation here, https://support.google.com/docs/answer/3093150, but the SORT() function would order my columns on a column-by-...
user avatar
0 votes
1 answer
9 views

Formula to count number of cells with a name in if it matches this month

looking for a formula that will count names in one column if it matches another date column which is this month. Column A - Name Column B - date Column C, Row 1 = todays date The formula would look at ...
user avatar
0 votes
1 answer
12 views

Temporary importhtml function

This is hard to explain so I will try my best. I know how to use import html. I have been using it for NFL research for a while now. But I don't like how many times i need to repeat it for every ...
user avatar
0 votes
0 answers
21 views

Automating a summarized schedule

I'm in a community that goes about doing things during the week with leaders of said things being scheduled in to lead that event. We have a big schedule board where all of the leaders in a column and ...
user avatar
0 votes
1 answer
20 views

Get a count after a specific date grouped by person

I have a Google Sheet with dates in Column C, alphanumeric in Column E, and Employee Names in Column F. I am trying to figure out how to build a query to give me a count for each employee listed in ...
user avatar
  • 11
0 votes
1 answer
17 views

How to isolate the next due date from a list of dates in Google Sheets?

I have a spreadsheet with a list of tasks and due dates in Google Sheets (Column E). I have an adjacent column which tracks the status of the task as either "Pending", "In Progress"...
user avatar
0 votes
1 answer
47 views

ArrayFormula and Categorize Data in Google Sheets using Regular Expressions

I'm following this post to categorize data in Google Sheets using regular expressions. The person who wrote the answer was able to get the formula to automatically write down the category in column D. ...
user avatar
0 votes
0 answers
14 views

Is there a way to make one change to multiple spreadsheets in google sheets?

I am a business intelligence specialist for Google Sheets. I make google sheets for businesses to collect data from their members/volunteers. Most of my business comes from returning clients that are ...
user avatar
0 votes
1 answer
23 views

Combine two formulas for multiple inputs

I'm attempting to figure out how to combine these two formulas when there are multiple inputs. Example inputs: https://tracking.com/123456789 https://tracking.com/123456789?ABCD =SUBSTITUTE(SUBSTITUTE(...
user avatar
  • 1
0 votes
1 answer
23 views

My IFS MATCH Formula wont return correct

I'm trying to use sheets to help calculate a players level based on xp, there are 2 things that effect how much xp is needed to level up, one is a reduction of xp needed by 5% and the other increases ...
user avatar
0 votes
1 answer
14 views

Create chart in Google Sheets to predict win/loss data over time [closed]

I've been unable to find tips to apply to my scenario. I keep data on gambling wins and loses. I want to create a chart in Google Sheets to predict future win/loss data over time with dollars on the y-...
user avatar
  • 13
-1 votes
0 answers
14 views

How can i calculate compound interest (compounded quarterly) between 2 dates in google sheets [duplicate]

Is there a simple formula to calculate compound interest between two dates which gets compounded quarterly?
user avatar
0 votes
0 answers
16 views

Script that adds a row with formulas from previous columns while also sorting

I have a script that I enter B2, B5, E2, & E5 that will add it to the bottom row of the list. I'm needing to add the formulas that are all different from columns E:Y along with it and be able to ...
user avatar
0 votes
1 answer
31 views

Google Workspace Marketplace only shows first 100 sheets add-ons

When I select "Works with Sheets" on Google Workspace Marketplace, it only shows exactly 100 add-ons. I do not see any "More" button or any other way to see other than these 100. I ...
user avatar
0 votes
1 answer
19 views

How to pull multiple values based on date ranges

I have this list of events (A) that has a start (B) and end date (C). Now what I try to achieve is to create a new list of days (E), like a calendar, that collects all events taking place that day (F)....
user avatar
  • 3
0 votes
0 answers
20 views

Importrange changes the format only for a couple cells

I am using importrange and for some cells google sheets changes the format of only a couple cells. I have attached a screenshot. The original worksheet has the correct dates M/DD/YYYY. So I am ...
user avatar
  • 1
0 votes
1 answer
15 views

importing data from several sheets and average without including 0s

I have the following formula: =query({'6th LA'!A2:G66;'6th SS'!A2:G66;'6th Math'!A2:G66;'6th Sci'!A2:G66;'7th LA'!A2:G93;'7th Sci'!A2:G93;'7th SS'!A2:G93;'7th Math'!A2:G93;'8th LA'!A2:G80;'8th SS'!A2:...
user avatar
0 votes
1 answer
22 views

For Google Sheets, what is the function that will populate a cell with specific text when pulling data from multiple tabs of another sheet?

I am building a Google Sheet that pulls data from another Google Sheet with multiple tabs. The source sheet doesn't include one particular data point (i.e. business name), and I want to populate the ...
user avatar
0 votes
2 answers
26 views

How get the cost price?

I have the following spreadsheet: For column B, the formula is simple: B1 + (B1 * A2) The question is: how to get the numbers in column C? I manually typed all values on column C but the idea is if I ...
user avatar
0 votes
0 answers
25 views

Google Finance Sheets: Dividends and Stock Splits

I am building a Google Finance Spread Sheet for my portfolio and curious about a few things. Generally, I am trying to calculate the monthly returns for each month and essentially outputted the ...
user avatar
0 votes
2 answers
16 views

Cascading a date & absolute value that references another dated sheet

https://docs.google.com/spreadsheets/d/e/2PACX-1vTyyem2spUQAi44lPN3rk_AQiE1J-OS2nQtJbASYadyXZ8WmjHR-yNjY1fH2jRwttyUiOPtf6uL3xBs/pubhtml I'd like to be able to click and drag to auto-populate the cells ...
user avatar
0 votes
1 answer
10 views

How Do I Only Show items that have <2 on the graph?

I need to make a bar graph in google sheets to show how many complaints each dealer received, however I don't want the graph to show the dealers with only >2 complaints. How can I make the graph ...
user avatar
  • 1
0 votes
1 answer
20 views

Help with Google Sheets Formula

I previously asked for help with a formula here I was able to put together a formula but now need to add some additional functions to it & I am lost now. My current formula is this: =proper(...
user avatar
  • 1
0 votes
1 answer
25 views

How print power as 2^5 without get result 25

I try to get inside cell of google sheets I try 2^5, but it gives 25 or shows 2^5. How should it be done?
user avatar
  • 103
0 votes
2 answers
43 views

Google Spreadsheets-Autosort but with a second argument

This is the link to a Google Spreadsheet for use in a fishing club. https://docs.google.com/spreadsheets/d/17xFDHoF_-3Kg7jVrxiIRjBJy-DD70RFg6wPf19fQC50/edit#gid=943629989 When the fishing tournament ...
user avatar
  • 3
0 votes
3 answers
29 views

reference this exact cell (x,y) of another sheet

Please, imagine the following scenario. Document consists of 2 sheets: sheet1, sheet2. Sheet1 has 4 cells filled in. A1, A2, B1, B2. Bonjour, S'il vous plaît, Merci, De rien - all 4 cells are in ...
user avatar
  • 1
0 votes
0 answers
21 views

Slicer remains filtered

Every time I open a specific google sheet I have one slicer that keeps being filtered even though I clear the selection and make the non filtered view as a default. Any ideas on how to prevent this ...
user avatar
  • 1
0 votes
1 answer
13 views

How to make a variable relative to the sheet it is in?

In Google Sheets, I can define a variable such as interestRate by using Data -> Named Ranges. Then I can use the variable interestRate as if it is a number, like 10%. But what if in Sheet2, I want ...
user avatar
0 votes
2 answers
24 views

Google Sheet formula on showing the lowest number if none of the values equals 0 does not work

I'm trying to create a formula that meets the following conditions: If any of the cells is 0, then just show 0 If none of the cells equals 0, then show the lowest number of those cells So let's say ...
user avatar

1
2 3 4 5
163