Skip to content
f(x)
∑
=
Power Features

Your spreadsheet, butsupercharged.

Everything you need to write, debug, and manage complex formulas without the headache.

A code editor, built for formulas.

Painless editing – Our multi-line code editor, plus improved readability via syntax highlighting, structured formatting, and indentation.

  • Color-coded functions and ranges to easily spot errors or references.
  • Auto-suggest for formula functions and range names as you type (no more memorizing every function name).
  • Find & replace within formulas to quickly update field names or values.
  • Dark mode and customizable font size for comfortable long work sessions.
Watch Demo
editor.js
=IFS(
  D14 > @@Threshold, “Approved”,
  AND(D14 > 0, C14 = “VIP”), “Review”,
  TRUE, “Reject”
)

Excel syntax support.

Compatibility mode to convert Microsoft Excel™ formulas to Google Sheets™ and vice versa, so you never get stuck rewriting formulas.

  • Supports conversion of most Excel-specific functions (e.g., XLOOKUP, SUMIFS differences) into Google Sheets™ equivalents and alerts if something isn’t directly transferable.
  • Also helps identify Google Sheets™ functions that have different names in Excel (e.g., ARRAYFORMULA usage or date functions).
  • Reduces migration headaches when moving legacy spreadsheets to Google Sheets™ for collaboration.
  • Accurate description for every formula in Google Sheets™ and Microsoft Excel™.
Watch Demo
X
Excel
Sheets
Excel Input
=XLOOKUP(A2, D:D, E:E)
Sheets Output
=ARRAYFORMULA(XLOOKUP(A2, D:D, E:E))

Visual formula builder (no-code formula creation).

Visual tool to build formulas step by step without writing code.

  • Real-time preview of the formula as it’s built, so you learn the syntax as you go.
  • Reduce errors by filling arguments through form fields.
  • Built-in field validation.
  • Add endless amount of nested groups and expressions without thinking about syntax.
Watch Demo
Formula Builder
QUERY
SELECT A, B, SUM(C)
WHERED = ‘Active’

Variables, finally.

Define variables (like exchange rates or constants) and use them in formulas across your workbook, all updated in one place.

  • Create and manage variables (like exchange rates, constants, targets) in a dedicated sidebar. Update the value in one place.
  • Use variables in formulas by name (e.g., use @@TaxRate inside a formula) – Formula Foundry will replace it with the value behind the scenes.
  • Ensure consistency: all team members use the same approved values, which is great for financial and business reporting integrity.
  • Easily toggle or update variables for scenario analysis (e.g., quickly see how changes in @@InterestRate affect all your calculations).
Watch Demo
{ } Variables
+
@@TaxRate…
0.21
@@Q4_Forecast…
=SUMIFS(‘Sales’!E:E, ‘Sales’!B:B, “>=2023-10-01”) * (1 + @@Growth)

Your personal AI assistant.

Use AI to suggest formulas or explain complex ones in plain English, then fine-tune with the editor.

  • Natural language to formula: speed up formula creation when you’re unsure how to start.
  • Formula explain: paste a confusing formula and get a step-by-step explanation in seconds (great for learning or auditing complex sheets).
  • Error debug suggestions: if a formula isn’t working, the AI can hint at what might be wrong (missing range, misused function, etc.).
  • Saves time especially for novice users, while still helping them learn how the formula works for the future.
Watch Demo
How do I sum column A only if column B is “Paid”?

Use SUMIF. Here is the formula:

=SUMIF(B:B, “Paid”, A:A)

Reusable snippets library.

Stop reinventing the wheel. Formula Foundry includes a snippet library where you can save and reuse pieces of formulas or entire formulas. If you’ve mastered a tricky array formula or a perfect regex, save it as a snippet and insert it later with one click. This is a lifesaver for common tasks.

  • Create your own snippets from any formula and give them names for easy recall.
  • Snippet search: quickly find a saved formula by typing keywords.
  • Sync snippets across your devices (logged-in Google account) – your library goes where you go.
  • Save your snippets for both: formula editor and formula builder.
Watch Demo

Snippets

12 saved snippets

+ New Snippet
🔍
MRR CalculationTeam
Modified 2h agoEditor
Email Regex ValidatorPrivate
Modified yesterdayEditor

Built for Teams & Enterprise

Centralized Billing

Custom SSO

Domain Invites

Ready to forge better formulas?

It’s time to upgrade your workflow.

Install for Free
View Pricing

14-day free trial • No credit card required

Frequently Asked Questions

Yes – we offer a free 14-day trial for all plans. Install the add-on and you’ll automatically have access to all features. No credit card required.
After the trial period is over, you’ll be offered to subscribe to one of our products.

For “Starter” or “Pro” plans, billing is monthly (cancel anytime) or yearly (2 months for free for annual). Managed via our secure payment portal.

Absolutely. Formula Foundry doesn’t store your spreadsheet data. All computations happen within your Google Sheets™. We only store your name, email address and snippets in our database which can remove anytime by request. We comply with Google’s security standards for Google Workspace™ add-ons.

We’re here for you. All users have access to our online documentation and contact forms. We also love feedback – many of our new features come from user suggestions!