We’re improving Formula Genius. We’re redesigning the app and fixing issues along the way. Sorry for any disruption, and thank you for your patience.

Check an Airtable formula

Paste a formula and describe what it should do. Get a static rule review with links to Airtable’s documentation. Nothing runs in Airtable.

Check a formula See the sample

A real sample result

A real static rule review. Intended outcome: Show the order amount when the status is Done.

Formula field. Field list marked complete: Status (select), Order ID (text), Amount (number).

IF({Status}="Done", XLOOKUP({Order ID}, {Orders}, {Amount}), SUM({Linked Amounts})

  • Check quotes and brackets

    A quote, field brace, or grouping bracket is incomplete or mismatched.

    Airtable documentation

  • Function needs review

    “XLOOKUP” is not in the documented Airtable function catalog checked on 14 October 2026.

    Airtable documentation

  • Field not in your list

    “Orders” is not in the supplied field list.

    Airtable documentation

  • Field not in your list

    “Linked Amounts” is not in the supplied field list.

    Airtable documentation

Test the formula in Airtable against your intended outcome and actual records.

What it checks

  • Quotes, field braces and grouping brackets for incomplete or mismatched pairs.
  • Field names against the names and types you supply.
  • Function names against Airtable’s documented catalog. Spreadsheet-only functions such as XLOOKUP are flagged.
  • Selected array, lookup and rollup rules based on the context you provide.
  • Literal regex patterns for lookarounds and numeric backreferences that Airtable’s RE2 does not support.

What it does not check

  • It does not connect to your base, read records or run the formula.
  • It does not verify results or parse the full formula grammar.
  • A rule review depends on the field context you supply. Test the formula in Airtable against actual records next.

How it works

  1. 1. Sign in

    Use a free sign-in. This review uses no credits or daily quota.

  2. 2. Provide the context

    Paste up to 2,000 characters. Describe the intended outcome, choose formula field or rollup, and list your field names and types.

  3. 3. Review and test

    Read each finding and its documentation link. Then test the formula in Airtable.

Frequently asked questions

Does it use AI?

No. This is a static rule review. It does not run the formula or read records.

Do I need to connect my base?

No. You supply the formula and field context. There is no base connection, and the formula is not stored.

Is there an allowance for these checks?

A free sign-in is needed. The review uses no credits or daily quota.

What should I do with a finding?

Each finding links to Airtable’s documentation. Test the formula in Airtable against your intended outcome and actual records.

Review your formula’s rules

Bring the formula, its intended outcome, and your field names and types.

Check a formula