QUERY Function Formula Fixer and Explainer
Paste a broken Google Sheets QUERY formula and get a plain English explanation, the likely error, a corrected formula and a short test plan.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Explain and fix my Google Sheets QUERY formula. My formula: [QUERY_FORMULA]. The error or wrong result: [ERROR_OR_PROBLEM]. Sample rows from the source range with headers (invented or anonymised): [SAMPLE_ROWS]. What the output should look like: [EXPECTED_OUTPUT]. Respond in this order: 1. Plain-English explanation of what the formula currently tries to do, one sentence per clause. 2. The most likely cause of the problem, with the exact part of the formula that is responsible, and two backup suspects. 3. A corrected formula in a code block, plus a short list of exactly what you changed and why. 4. A test plan: three quick checks I can do on a small range (row counts, one total checked by hand, one edge case such as empty cells). 5. A "cleaner version" suggestion if the formula can be made easier to read or maintain, for example by moving filter values into cells. If you cannot tell the cause from what I gave you, ask for the missing detail instead of guessing, and list the two things you would check first. Do not change what the formula is meant to show without telling me. Mark anything that depends on regional settings, date formats or sheet version as [VERIFY].
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.