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.

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:
- Count rows where Category is Bug
- Sum Amount for rows where Status is Paid and Date is in October 2026
- Return the email from column D for the customer in A2, looked up in the Customers sheet
- Flag rows where column F is more than 10% above the average of F
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.