# using-formula-functions

> Claude/Codex skill by [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars · Updated 2026-10-23

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

```sh
git clone https://github.com/gopigment/ai-plugins /tmp/ai-plugins && ln -s /tmp/ai-plugins/skills/using-formula-functions ~/.claude/skills/using-formula-functions
```

## From 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()).

## Links

- HTML page: https://omgskills.com/library/gopigment/ai-plugins/skills/using-formula-functions/
- GitHub: https://github.com/gopigment/ai-plugins
- Author: [@gopigment](https://omgskills.com/library/gopigment/index.md)

## More from this repo

- [aggregating-view-data](https://omgskills.com/library/gopigment/ai-plugins/skills/aggregating-view-data/index.md) — Execution skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars
- [architecting-multi-application-solutions](https://omgskills.com/library/gopigment/ai-plugins/skills/architecting-multi-application-solutions/index.md) — Planning skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars
- [auditing-a-pigment-application](https://omgskills.com/library/gopigment/ai-plugins/skills/auditing-a-pigment-application/index.md) — Execution skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars