Individual skill

spreadsheet-automation

Designs spreadsheet automation using built-in features including named ranges, drop-down validation lists, INDIRECT references for dynamic ranges, array formulas, and QUERY/FILTER functions. Produces the specific formula strings for self-updating, self-validating spreadsheets. Use when the user wants to make their spreadsheet more automated, dynamic, or self-maintaining without VBA or scripts. Do NOT use for data validation rule design (use data-validation-setup), data cleaning formulas (use spreadsheet-data-cleaning), or Google Apps Script programming (software-development scope).

src/process/resources/skills-library/bodies/skills/data-analysis/spreadsheet-automation/SKILL.md

Source commit 4c030c7b01c241df7b6e3535635a970f10d781af

What was checked

Matches the observed repository HEAD

Yes

Scanner rules are current

Yes

Repository scan complete

No

Skill scan complete

No

Observed behavior

Instructions only

Last checked

Nov 10, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.