Codex · Community skill
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.
What this skill covers
This page keeps a stable Remote OpenClaw URL for the upstream skillwhile preserving the original source content below. The shell stays consistent, and the body can vary as much as the upstream SKILL.md or README varies.
Source files and registry paths
Source path
spreadsheet-formula-helper
Entry file
spreadsheet-formula-helper/SKILL.md
Repository
ComposioHQ/awesome-codex-skills
Format
skill-md
Original source content
Raw file# 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.
Related Codex skills
awesome-codex-skills
Brand Guidelines
Applies OpenAI's brand colors and typography to any artifact that should match the Codex/OpenAI look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.
awesome-codex-skills
Canvas Design
Create beautiful visual art in .png and .pdf documents using design philosophy. You should use this skill when the user asks to create a poster, piece of art, design, or other static piece.
awesome-codex-skills
Changelog Generator
Automatically creates user-facing changelogs from git commits by analyzing commit history, categorizing changes, and transforming technical commits into clear, customer-friendly release notes. Turns hours of manual changelog writing into minutes of automated generation.
awesome-codex-skills
Codebase Migrate
Run large codebase migrations and multi-file refactors. Uses the Composio CLI to coordinate issue tracking, batched PRs, and CI verification while the agent executes the transforms locally across hundreds of files.
awesome-codex-skills
Competitive Ads Extractor
Extracts and analyzes competitors' ads from ad libraries (Facebook, LinkedIn, etc.) to understand what messaging, problems, and creative approaches are working. Helps inspire and improve your own ad campaigns.
awesome-codex-skills
Connect
Connect Codex to any app via the Composio CLI. Send emails, create issues, post messages, update databases - take real actions across Gmail, Slack, GitHub, Notion, and 1000+ services from the terminal.
