← LeaderboardThe Skill Leaderboard

spreadsheet-formula-helper

Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.

Published by composio-community ↗composio-community/awesome-codex-skills

Try your first task

Draft and verify one spreadsheet formula

Start a fresh conversation. Replace the highlighted placeholders.

Use the spreadsheet-formula-helper skill to write a formula for [desired result] using the sample layout below. Give the primary formula, explain where to place it, and show a 2–3 row worked example including relevant blank, duplicate, or mixed-type edge cases.

Required inputs

  • Platform: Excel or Google Sheets
  • Locale and formula separator
  • Sheet names, headers, and cell ranges
  • A small sample of rows
  • Expected output and constraints

Suggested template by Skill Leaderboard, grounded in the linked source. Task evidence ↗

SKILL.md

name: spreadsheet-formula-helperdescription: Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.metadata:   short-description: Build/debug Excel or Sheets formulas

Spreadsheet Formula Helper

Produce reliable spreadsheet formulas with explanations.

Inputs to gather

  • Platform (Excel/Sheets), locale (comma vs. semicolon separators), sample data layout (headers, ranges), expected outputs, and constraints (volatile functions allowed?).
  • Provide small example rows and the desired result for them.

Workflow

  1. Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify.
  2. Draft formula(s); when dynamic arrays are available, prefer them over copy-down formulas.
  3. Explain how it works and where to place it; include named ranges if helpful.
  4. Edge cases: blank rows, mixed types, timezone/date quirks, duplicates; offer guardrails (e.g., IFERROR, LET, LAMBDA).
  5. Variants: if porting between Excel and Sheets, provide both versions.

Output

  • Primary formula, short explanation, and a 2–3 row worked example showing inputs → outputs.
  • Optional: quick troubleshooting checklist for common errors.