AI in formulas

Write AI like a formula.

Ask a column a question and the answers land in the grid. No export, no separate AI tab, no copying results back in by hand. It is a formula, so it fills down, filters, groups and rolls up like every other column you have.

Start free trialAll features →
Support inbox
fx=CLASSIFY([Feedback]@row, "bug, praise, question")
FeedbackTypeSeverity
Login times out on mobilebughigh
Love the new dashboardpraiselow
Can I export to Excel?questionlow
Data lost after refreshbughigh
Filled by formula. Recalculates like any other column.
Four functions

Classify, extract, summarize, or just ask

Most of what people want from AI on a spreadsheet is one of three jobs: put this in a bucket, pull this field out, make this shorter. Those are three functions. The fourth is there for everything else.

Fills down
One formula, then the whole column
Real values
Filter, group and roll up the results
Four functions
=CLASSIFYTag a column against your own labels
=CLASSIFY([Feedback]@row, "bug, praise, question")
=EXTRACTPull one field out of messy text
=EXTRACT([Email]@row, "purchase order number")
=SUMMARIZECondense a long note to a line
=SUMMARIZE([Call notes]@row, 20)
=AIAnything the other three do not cover
=AI([Scope]@row, "list the risks")
Metered at cost

The ceiling is real, not a warning

Usage is metered in dollars at what it actually costs, with no markup. Your monthly allowance is a hard ceiling: when it is spent, the functions stop and say so. A formula dragged down ten thousand rows cannot turn into a surprise invoice, which is the failure mode that makes people afraid to use AI in a sheet at all.

No markup
You pay what the tokens cost
Hard stop
Spent means stopped, not throttled
AI budget
Included this month$5.00
Used$1.90
Remaining$3.10
At $0.00 the AI functions stop and return a clear error. They never keep spending, and nothing silently accrues to next month’s invoice.
How it works
Write it once
Put =CLASSIFY([Feedback]@row, "bug, praise, question") in the first cell.
Fill it down
Every row answers for itself. Results are cached, so untouched rows do not re-spend.
Use the answers
They are ordinary values: filter on them, group by them, chart them on a dashboard.
Watch the budget
A live meter in the app, and a hard stop at zero rather than an overage.
Frequently asked
Is this a chatbot bolted onto a spreadsheet?

No. It is four functions in the formula engine. You write one in a cell, fill it down a column, and the answers land as values you can filter, group and roll up like any other column.

What stops it running up a bill?

The monthly allowance is the hard ceiling, not a soft warning. When the budget reaches zero the functions stop and return an error. You can top up deliberately, and top-ups are face value with no markup on the underlying usage.

Does it recalculate constantly?

Results are cached against the input, so an untouched row does not re-spend. Change the source text and that row recomputes.

What syntax do I write?

Wisegrid syntax: [Column name]@row refers to the current row, so =CLASSIFY([Feedback]@row, "bug, praise") reads the Feedback cell beside it. The engine expands @row itself.

What happens if the model cannot answer?

The cell shows an error value rather than a confident guess, so a wrong answer never quietly enters a rollup.

Keep exploring

AI Consultant

The other half: describe the process you run and watch it get built.

Read →

Formula reference

The full function library, with the syntax and worked examples.

Read →

What's included

One price, and the capabilities other suites meter as premium add-ons.

Read →

Put it in a real column.

Start your 7-day free trial and classify your own messy column. No credit card required to start.

Start free trialMigrate from Smartsheet →