Data & Analysis
Beginner
Google Sheets QUERY function-3
Write complex Google Sheets QUERY formulas to filter data tables.
👁️ 3581 views
❤️ 99 likes
📋 425 copies
The Prompt Template
Write a Google Sheets QUERY formula to extract data from a table in sheet '[SHEET_NAME]' (range A:Z). Filters: [FILTER_CONDITIONS: e.g. sales > 1000, date is this month]. Sort order: [SORT_COL]. Explain how the select statement works and how to handle empty results.
266 characters
Tags
Works Best With
ChatGPT Gemini