---
name: spreadsheet-formula-helper
description: "The formula, plus enough explanation to adapt it next time. Use when the user wants help with Spreadsheet Formula Helper. Related topics: Data, Spreadsheets, Productivity."
---

# Spreadsheet Formula Helper

The formula, plus enough explanation to adapt it next time.

## How to use this skill

1. Ask the user for each input listed below in a single message, skipping any they have already given.
2. Where options are listed, offer them, but accept other answers too.
3. Fill the answers into the prompt template, then follow the completed prompt to produce the result.

## Inputs

- **What I'm trying to do** (longer free text)
- **How my sheet is laid out** (longer free text)
- **Tool** (choose one: Excel, Google Sheets, LibreOffice, Numbers)
- **What I've tried** (longer free text)

## Prompt template

What I'm trying to do: {{What I'm trying to do}}

How my sheet is laid out: {{How my sheet is laid out}}

Tool: {{Tool}}

What I've tried: {{What I've tried}}

Give me the formula with references matching my layout, then break it down so I can adapt it. Handle blanks, duplicates and text mixed with numbers rather than assuming clean data. If a helper column makes it simpler, use one. Tell me where it breaks if rows get inserted.

---

Source: [Spreadsheet Formula Helper on PromptBuild](https://promptbuild.io/prompt/IUMX8FQp6WPsgmzta5Pi/spreadsheet-formula-helper)