Data & Analysis
Beginner
🔥 Trending
Google Sheets QUERY function
Write complex Google Sheets QUERY formulas to filter data tables.
👁️ 5182 views
❤️ 200 likes
📋 562 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