Debug Complex Formulas With Gemini
Paste a broken or confusing formula, find out what went wrong and how to fix it
You open a critical sheet and see a formula error, or a result that makes no sense. The original builder left the company, or you wrote it six months ago and forgot the logic.
That is the gap this drop closes. It is a data & analysis skill built for Gemini, and it takes about ten minutes to set up the first time. After that it runs in under a minute.
Who should use it
Analysts and team leads who inherit sheets from others or whose own formulas stopped working
How it works
The skill file does five things, in this order.
1. Copy the entire formula cell. Include the equal sign and everything inside, even if it spans multiple lines or references other sheets.
2. Describe what you expected to happen. Tell Gemini the purpose of the formula and what output you need, not just that it is broken.
3. Paste sample data from the range. Give three to five rows so Gemini can test logic against actual values, not abstractions.
4. Ask for the error explanation first. Request a plain breakdown of what each part does and where the logic fails before jumping to a fix.
5. Request a corrected version with comments. Get the working formula annotated so you understand the change and can maintain it later.
What comes back
A clear diagnosis of the formula error, a corrected version you can paste directly, and enough understanding to prevent the same mistake next time
The mistake to avoid
If the formula references named ranges or other sheets, include those names and a sample of what they contain. Gemini cannot see your actual spreadsheet, so context is everything.
Running it
Save the prompt as a Gem so it is reusable, or paste it into Gemini with your files attached. If the task touches Sheets, Docs or Gmail, run it from the Workspace side panel so it can read the file you already have open.
Where this fits
On its own, one skill saves an hour a week. The compounding happens when three or four of them run in sequence on the same input, the same transcript that produces a scope of work also produces the follow-up email and the project brief. That is the point at which it stops being a prompt and starts being an internal tool. If you want that wired into the systems your team already uses, that is the work 67 Digital does.
In the file
I have a Google Sheets formula that is not working as expected.
Formula:
{paste_full_formula_here}
Purpose:
{describe_what_this_formula_should_calculate_or_return}
Sample data from the range it references:
{paste_3_to_5_rows_with_column_headers}
Current result:
{what_the_formula_currently_returns_or_error_message}
Expected result:
{what_you_need_it_to_return}
Please do the following:
1. Explain what each part of this formula does
2. Identify where the logic is failing or producing the wrong result
3. Provide a corrected formula
4. Annotate the corrected formula with comments explaining each section
5. Suggest how to test the fix with my sample data
If you need more context about the data structure or any named ranges, let me know what information would help.