Skip to content
{ }
∑
available now

Stop wrestlingwith formulas.

Formula Foundry is a Google Sheets™ add-on that makes writing, understanding, and managing formulas fast and easy – save hours, reduce errors, and boost productivity.

Install for Free
Watch Demo

14-day free trial • No credit card required

InsertViewSnippets
Pro
Microsoft Excel
‘Q3 Financials’!D14
1
2
3
4
5
6
7
=IF(ISERROR(VLOOKUP(A2, @@Prices, 2, FALSE)),“Not Found”,VLOOKUP(A2, @@Prices, 2, FALSE))
=IFERROR(VLOOKUP(A2, ‘Prices’!A:B, 2, FALSE), “Not Found”)

The editor space you’ve always wanted.

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)

What our clients say

“

I always wanted a larger, number-delineated entry field for editing longer formulas — Formula Foundry’s editor truly delivers!

Will Kaufman
Will Kaufman
Sr. Customer Success Manager
“

Opening Google and/or ChatGPT for syntax and formula writing assistance was always helpful, but one more step in my workflow – Formula Foundry simply added the power of AI directly into Google Sheets, and it’s super convenient!

Yurii Vasyliev
Yurii Vasyliev
CTO, Engineer
“

This tool saved me hours of work. Absolutely essential.

Peter Kurkowski
Peter Kurkowski
Sr. Product Marketer

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!