using-formula-functions
Execution skill. Use when drafting or debugging a Pigment formula that calls built-in functions. Covers all function signatures, parameters, return types, and usage examples grouped by category.
Install
With your agent
Install OMGSkills skill "gopigment/ai-plugins:skills/using-formula-functions" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
git clone https://github.com/gopigment/ai-plugins /tmp/ai-plugins && ln -s /tmp/ai-plugins/skills/using-formula-functions ~/.claude/skills/using-formula-functionsFrom README
Pigment Formula Functions — Quick Reference Pigment has its own proprietary formula language. These are NOT Excel/SQL/Python functions. Use only Pigment syntax. How to Use Find the function below, then open the matching sub-file for full signatures, parameters, return types, gotchas, and examples. Match function name exactly (case-sensitive); pass parameters in documented order. Critical Global Rules BLANK ≠ FALSE: BLANK is not stored (sparse); FALSE is stored (dense) Division by zero/BLANK → BLANK automatically; no guard needed AND / OR / NOT: infix/prefix operators (A AND B, NOT cond), not function calls Sparsity preference: ISDEFINED > IFDEFINED > IFBLANK > IF(ISBLANK()).