PlaybookPrompts

Generate a Google Sheets / Excel formula from a description

Data & Analysis sheetsexcelformulas

Spreadsheet formulas have many ways to be wrong. This prompt produces the formula plus a verification step.

Prompt 
Generate a spreadsheet formula for: {{DESCRIPTION}}

Platform: {{PLATFORM}} (Google Sheets / Excel)
My data shape: {{DATA_SHAPE}}
Where I want the formula: {{TARGET_CELL}}

Produce:
1. The formula, ready to paste.
2. A 1-line explanation of what each function in the formula does.
3. A second, equivalent formula written differently — useful if the first one breaks on an edge case.
4. The single most likely failure mode (e.g., 'returns #N/A when the lookup value isn't in the source range') and how to guard against it.
5. A test row I can paste above my data to verify the formula works.
Variables to fill in
  • {{DESCRIPTION}}
  • {{PLATFORM}}
  • {{DATA_SHAPE}}
  • {{TARGET_CELL}}

How to use this prompt

  1. Copy the prompt above (Copy button on the top-right).
  2. Replace each {{VAR}} with your own value. Variables: {{DESCRIPTION}}{{PLATFORM}}{{DATA_SHAPE}}{{TARGET_CELL}}.
  3. Paste it into one of the recommended tools below.
  4. Iterate: tighten constraints in the prompt if the output is generic.

Why this prompt is structured this way

The prompt is split into explicit steps because LLMs do better when the path is named, not implied. Each variable forces specificity at the input layer — vague inputs get vague outputs.

Heads up: some of the links on this page are affiliate links — meaning we may earn a commission if you sign up after clicking, at no extra cost to you. We only recommend tools we'd put on our own stack. You can see our full affiliate disclosure here.

Pair this prompt with a tool

Claude (Anthropic)

$0/mo (Pro at $20)

Frontier model with long context and strong reasoning.

Claude (Opus / Sonnet / Haiku tiers) is the assistant favored by writers and engineers who care about reasoning quality and tone. 1M token context on Opus.

writingcodinglearning

ChatGPT (OpenAI)

$0/mo (Plus at $20)

The category-defining general-purpose AI assistant.

ChatGPT has the broadest feature surface: image gen, voice, custom GPTs, web browsing, code execution. Often the right default; sometimes beaten on specific tasks by Claude or Perplexity.

writingcodinglearning

Perplexity

$0/mo (Pro at $20)

AI search engine with citations.

Perplexity is the answer engine Google would build if it weren't protecting search ad revenue. Cited answers, follow-up questions, focused source modes.

learningdata

The PlaybookPrompts weekly

One short email per week. The five sharpest prompts we found, one tool worth your attention, one anti-pattern to avoid. Unsubscribe in one click.

Newsletter signup is not configured. Set PUBLIC_NEWSLETTER_USERNAME in the build env.