Train Your Team to Write Their Own Formulas
Get everyone building accurate spreadsheet formulas without constant requests to you
You spend hours each week writing formulas for team members who could solve their own problems. When you are unavailable, work stops or errors multiply because no one else knows how to build or check the calculation.
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
Team leads whose inbox fills with formula requests from colleagues who work with data
How it works
The skill file does five things, in this order.
1. Create a shared prompt template. Write one standard prompt the whole team will use, with blanks for their specific sheet structure and calculation need.
2. Document your column naming rules. Tell the team exactly how to describe their columns so Gemini understands the data type and location every time.
3. Run three live examples together. Walk the team through building formulas for simple, medium and complex cases in a working session so they see the pattern.
4. Set a verification checklist. Give your team four checks to run on every AI-generated formula before they use it in live data.
5. Schedule monthly formula reviews. Book 30 minutes each month to look at formulas the team built, catch recurring mistakes, and refine the shared prompt.
What comes back
Your team asks AI for their own formulas and you review work instead of writing it from scratch
The mistake to avoid
Keep a shared document where team members paste the prompts that worked well for specific calculation types. New hires can copy proven prompts instead of starting blind.
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 need a Google Sheets formula for my team to use consistently.
Sheet structure:
- Column {column_letter}: {data_type} called {column_name}
- Column {column_letter}: {data_type} called {column_name}
- [List all relevant columns]
Calculation required:
{describe what needs to be calculated in plain words}
Constraints:
- Formula will be used in column {target_column} starting at row {start_row}
- Data runs from row {first_data_row} to row {last_data_row}
- {any special conditions, such as: ignore blank cells, only count if status is X, apply to entire column}
Provide:
1. The complete formula ready to paste
2. A one-sentence explanation of what it does
3. One common mistake to avoid when someone copies this formula to other rows or sheets
Format the formula as plain text, not as a code block.