Formula example
Google Sheets QUERY Another Sheet
You want to query rows from a tab named Raw Data and return selected columns where Status is Complete.
Copyable formula
=QUERY('Raw Data'!A1:D100, "SELECT A, B, D WHERE C = 'Complete'", 1)Sample data
| Task | Owner | Status | Due Date |
|---|---|---|---|
| Import leads | Maya | Complete | 2026-01-06 |
| Clean headers | Nico | In Progress | 2026-01-08 |
| Review budget | Maya | Complete | 2026-01-12 |
| Publish report | Iris | Blocked | 2026-01-15 |
Formula explanation
- Single quotes around the sheet name are needed when the tab name contains a space.
- The query string filters column C to completed rows.
- The formula returns only columns A, B, and D from the source range.
Common errors
- Forgetting single quotes around tab names with spaces.
- Using the wrong column letters after changing the source range.
- Filtering on display text that differs from the actual cell value.
Build your own version
Use the deterministic builder for this pattern: Google Sheets QUERY Formula Builder.
Related formulas
FAQ
Does this import from another spreadsheet file?
No. This example queries another tab in the same spreadsheet.
What if the sheet name has no spaces?
The quotes are still safe, but not always required.