Most spreadsheet cleanup is the same shape. Take a messy cell, pull one thing out, sort it into a bucket, or rewrite it. The problem is that every task needs a different formula.
People search "ai formula google sheets" because they want one function that does all of it. Something you point at a cell with instructions, not syntax.
The Old Way (A New Formula Per Task)
Extract a domain from an email? That is a REGEXEXTRACT with a pattern most people copy and never fully read.
=IFERROR(REGEXEXTRACT(A2, "@([a-zA-Z0-9.-]+\.[a-zA-Z]{2,})"), "")Map a messy job title to a department? Now it is a nested IFS with a keyword for every branch.
=IFS(REGEXMATCH(LOWER(A2),"developer|engineer"),"Engineering",REGEXMATCH(LOWER(A2),"sales|account"),"Sales",TRUE,"Other")Each one is brittle. Change the input format a little and the pattern breaks. And you rebuild the logic from scratch for the next column.
The FITS Way (One Formula, Plain English)
FITS gives Google Sheets a single AI formula. You write what you want as an instruction. The same function handles extraction, classification, and rewriting.
=FITS("Extract the email domain from this address: " & A2)=FITS("Map this job title to Engineering, Sales, Marketing, or HR: " & A2)Same function, different sentence. You can point it at a paragraph and ask for a summary, or a product name and ask for a category. No new syntax to learn each time.
=FITS("Summarize this customer note in one sentence: " & A2)When to Use Each
Native formulas are still best for math and for perfectly uniform data, where they are instant and free. Reach for the AI formula when inputs are messy, varied, or human-written, or when you would otherwise write a different formula for every column. For the full playbook of jobs this replaces, read automating Google Sheets tasks you used to need regex for. To see it tag feedback, try sentiment analysis in Google Sheets, and for cleaning inconsistent values first, see the normalize data guide.
One Formula for Every Messy Column
FITS puts a plain-English AI formula inside Google Sheets. Extract, classify, and rewrite without a new REGEX pattern each time. Free tier included.