Questions tagged [google-sheets-formula]
Do NOT share spreadsheets/images as the only source of data. Use markdown TEXT tables instead. Use this tag for Google Sheets questions that involve the use of spreadsheet formulas. Use together with tags such as [google-sheets] for broader visibility, [array-formulas], [google-query-language] or [custom-functions]+[google-apps-script] when the formula includes a custom function written in [google-apps-script]. Avoid use with [excel] and [excel-formulas].
google-sheets-formula
12,010
questions
-1
votes
1
answer
15
views
How extract partial data from one sheet to another sheet in Google Sheets
So I have to sheets, Expenses and Tax Expenses Overview. The Expenses sheet has it's data filled via a Google form where I track date of purchase, the category it fits, whether it's tax deductible, ...
0
votes
0
answers
4
views
How can i update data send by Hubspot to a Spreadsheet ? (Google Sheets)
I'm using hubspot CRM to send data daily to my spreadsheet:
In column A it fills with a GCLID
In Column B it fills with nothing
In Column C it fills if a UNIX date value
In Column D it fills with ...
-6
votes
0
answers
24
views
INDIVIDUAL SALES TACKER BASED ON MONTH [closed]
Have a large data base from which need to create a sales tracker based on month against each sales rep to show total sales value and deposit received..
sample sheet - https://docs.google.com/...
0
votes
0
answers
24
views
Can you use the relative cell value of a cell using XLOOKUP to get a formula in Google Sheets
Context
I'm trying to recreate a minigame to make a basic "heatmap" of the best decision to make. To do this I first decided to recreate the functionality of the game. The game consists of a ...
0
votes
1
answer
12
views
Count cell value if that pattern matches with two columns in google sheet
enter image description hereHow do I find the count of an value based on condition on two columns?
Here is an example:
So Column E2 and E3 has count 1 and 2 respectively because of number of available ...
-1
votes
0
answers
20
views
Return cells for which the sum of their row values = 20
I want to create a formula that returns the sum of any cells where the sum of their row value = 20. For example, B2+B22, B12+C12, B13+E15+G4, and so on. I also do not want it to call any cell twice in ...
-1
votes
0
answers
22
views
Cannot auto-Update google spreadsheet with data from an uploaded file [closed]
I cannot get IMPORTRANGE to automatically update a new separate google spreadsheet after uploading a "converted" csv file. 1: IMPORTRANGE will automatically update the new spreadsheet ...
0
votes
2
answers
24
views
Google Sheets, Array Formula, Target matching any of the cells in another tab
Currently I'm usinng the following formula
=ArrayFormula({"Somethingsomething"; if(len(X2:X),if((I2:I=3315)+(I2:I=3316)+(I2:I=3336)+(I2:I=3338)+(I2:I=3357)+(I2:I=3360)+(I2:I=3488)+(I2:I=3489)...
-1
votes
0
answers
21
views
How can I get the most recent date from multiple sheets?
I have a Google Sheet with a first Sheet called Technique. From A2 I have a list of different sheet name.
A2 = Envoi1; A3= Envoi2; ...
I have a sheet called Labels with A containing different name ...
-1
votes
0
answers
13
views
automated selection of drop-down value based on a text value in another cell, default should be emtpy drop-down menu
was looking for a solution and couldn't find one.
I have a google sheet with expenses I have(each row represents one expense) which I add every month.
in column A its just a text value I copy from the ...
0
votes
1
answer
25
views
How do I query for all cells in a column that contain an exact text, even if the cell also contains more text than what I'm querying for?
I've got a sheet with a column of cells that all contain unique text, but they are all different combinations of pre-determined phrases. So, in a new tab, I'd like to pull all the cells in column E ...
0
votes
2
answers
43
views
counting items in a column with comma separated lists and ordering them
I have a Google Sheet with a column of comma separated lists for example:
atl hip hop, dirty south rap, hip hop
atl hip hop, hip hop, rap
canadian hip hop, canadian pop, hip hop
I need help creating ...
0
votes
1
answer
21
views
Unable to write Query function in Google Sheets to compare both a cell value and date
The following query is breaking for me in Google sheets, and I can't determine what I'm doing wrong:
=sum(query(B:E, "SELECT E WHERE C = '"&S6&" AND B <= date '"&...
0
votes
1
answer
46
views
Set a cell background color based on a HEX value from another cell
From this question:
Set the background color to a cell based on a hex value
I'm looking for a formula that I can write down in a cell then in an adjacent cell appears the HEX color I wrote down. And ...
0
votes
0
answers
25
views
ImportHTML won't import commented out tables on Google Sheets
I've been attempting to collect football data on FBref using Google Sheet's ImportHTML function and while it works for the most part, it is having some issues with importing some tables.
I get the ...