Google Sheets Formula Builder Skill

Purpose

Constructs Google Sheets formulas from templates and validates syntax before application. Enables safe formula generation with type checking, cell reference validation, and error prevention.

Problem Solved

Manual formula creation is error-prone. Formulas with syntax errors, invalid references, or circular logic cause cascading failures in spreadsheets. This skill provides template-based formula generation with comprehensive validation ensuring only correct formulas are applied.

When to Use

• During formula application sprint phase
• When generating aggregate calculations (SUM, AVERAGE, COUNT)
• For conditional logic (IF, IFS, SWITCH)
• When building lookup operations (VLOOKUP, INDEX/MATCH)
• For array formula generation
• Before applying formulas to production sheets