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 data as markdown table to your question; this will greatly increase the chance that you get a satisfactory answer.
9,074 questions
0 votes
1 answer
21 views
Why isn't XLOOKUP returning NA when specifying a blank input
I'm using XLOOKUP as follows: =XLOOKUP(O49,INDEX(allPoolResults,,1),INDEX(allPoolResults,,3)),,,-1) However, I'm not getting an NA result when the match isn't found, despite skipping that argument. It'...
- 103
1 vote
2 answers
78 views
How can I filter values matching any element of a multiple selections dropdown using FILTER?
Background I have a spreadsheet with a range of source values, a dropdown from that range, and a FILTER that selects items from the source values matching the dropdown value: A B C D E 1 Key Value ...
- 158
0 votes
0 answers
11 views
How to make it grab the Near Mint price in particular rather than the Damaged? [duplicate]
using XPATHs to grab prices from TCGplayer for a Google Sheet to grab the price of a card. https://www.tcgplayer.com/product/42413?Printing=Normal&Language=English&page=1&Condition=Near+...
4 votes
2 answers
52 views
Function for displaying a value checked against another set of values
So I'd like to make a sign up sheet that is typically first come first serve, but in order to allow more people to get a turn for a recurring event, I want to compare the current sign up list to the ...
- 43
1 vote
1 answer
62 views
Inconsistent criteria for "blank" between COUNTBLANK and ISBLANK
I've discovered that COUNTBLANK and ISBLANK seem to use different criteria for what they consider a "blank" cell in Google Sheet. (test sheet link) Based on my testing, the logic of ...
- 11
1 vote
1 answer
45 views
updating an underlying table [closed]
I created a workbook for the guys that bought my cabinet shop to help them be consistent with pricing. It was in excel but i quit paying for that and rebuilt it (and improved it) in Google Sheets. ...
- 11
0 votes
1 answer
218 views
How to make a timeline chart of events + date in Google Sheets?
I asked Grok AI: How to plot a timeline of events with date in google sheets?. Grok says to make two columns of data such as: A B Event Name Date Project Start 2025-01-15 Meeting 2025-03-22 Deadline ...
- 109
1 vote
1 answer
58 views
Google Sheets if value is duplicate then mark TRUE on first value
I have a dataset similar to the image below. My goal is a formula to return what is in column C. If the Company (A) returns multiple times in the column, then in Column C only mark TRUE on the first ...
- 87