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.
Specification
- Skill ID
- composio-community/awesome-codex-skills/spreadsheet-formula-helper
- Publisher
- composio-community
- Repository
- awesome-codex-skills
- Installs
- 0
- Files
- 1
- Synced
- Sep 23, 2026
How to use it
Open any RiverX project, open the Skills panel in the chat, and search for this identifier. The files are fetched from the source repository at install time.
composio-community/awesome-codex-skills/spreadsheet-formula-helperInstalls these files- SKILL.md
What this skill tells the agent
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
- Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify.
- Draft formula(s); when dynamic arrays are available, prefer them over copy-down formulas.
- Explain how it works and where to place it; include named ranges if helpful.
- Edge cases: blank rows, mixed types, timezone/date quirks, duplicates; offer guardrails (e.g.,
IFERROR,LET,LAMBDA). - 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.
More from composio-community
Use this skill in a project
Open any RiverX project, search the Skills panel for composio-community/awesome-codex-skills/spreadsheet-formula-helper, and install it in one click.