Formula help

Describe a calculation in plain English and get a Google Sheets formula built around your headers.

Open the Formula help tab, describe what you want, and click Suggest formula.

Formula help

The add-on sends your description together with the headers in row 1 of the active sheet (so it knows that “Category” is column C) and gets back a formula and a one-sentence explanation.

Examples that work well:

Click Insert in selected cell to put it where your cursor is, then adjust. The generator uses Google Sheets functions (ARRAYFORMULA, QUERY, REGEXMATCH and friends), not Excel-only ones.

Each suggestion counts as one AI cell on the free plan.