Filtering Google Sheets Data to Another Tab Using Multiple Column Criteria

Other Questions Google Sheets
1

I’m looking for assistance with a Google Sheets query that filters entries based on two distinct columns.

At the moment, I’m utilizing this formula to retrieve data from our primary sheet:

=query('Survey Data'!A1:Z,"Select * Where G = 'Newsletter' ")

This works well for a single column filter, but I now wish to broaden my criteria. I want to include rows where column G is ‘Newsletter’ OR column P is ‘Yes’.

I’ve tried several approaches but haven’t had success:

=query('Survey Data'!A1:Z,"Select * Where G = 'Newsletter' ", "Select * Where P = 'Yes' ")

=query('Survey Data'!A1:Z,"Select * Where G = 'Newsletter' AND P='Yes' ")

=query('Survey Data'!A1:Z,"Select * Where G = 'Newsletter' OR P = 'Yes' AND Where P = 'Yes'")

What is the correct syntax for using an OR condition in a Google Sheets query function? I am trying to establish a filtered view that displays entries that meet one of these two conditions.

2

Had this exact issue last month building a dashboard for client feedback. You’re mixing multiple query statements or duplicating WHERE clauses - that’s what’s breaking it. Google Sheets query works like SQL but only takes one complete statement.

Here’s what works:

=query('Survey Data'!A1:Z,"Select * Where G = 'Newsletter' OR P = 'Yes'")

Watch out for data type mismatches with your headers and filter values. I once spent hours debugging because cells had trailing spaces. Add order by A at the end if you want sorted results.

3

you’re almost there! just drop the extra stuff and use: =query('Survey Data'!A1:Z,"Select * Where G = 'Newsletter' OR P = 'Yes'") - that’s it. you were overcomplicating it with multiple selects and extra wheres.

4

Your query syntax can be way simpler. Just use one WHERE clause for all your conditions:

=query('Survey Data'!A1:Z,"Select * Where G = 'Newsletter' OR P = 'Yes'")

I made the same mistake when I started with Google Sheets queries. Each query needs just one SELECT and one WHERE statement - throw all your conditions in there. The OR works exactly like SQL and grabs rows that match either condition.