Skip to content
{ }
BETA 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.

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”)

Your spreadsheet experience, reimagined.

Rich Formula Editor (Simple)
editor.js
=IFS(
  D14 > @@Threshold, “Approved”,
  AND(D14 > 0, C14 = “VIP”), “Review”,
  TRUE, “Reject”
)
Excel Translator
Excel
Sheets
=XLOOKUP(A2, D:D, E:E)
=ARRAYFORMULA(XLOOKUP(...))
Global Variables
{ } Variables
+
@@TaxRateSHEET
0.21
@@Q4_Forecast
GLOBAL
=SUMIFS(…) * (1 + @@Growth)
Visual Builder
Formula Builder
QUERY
SELECT A, B, SUM(C)
WHERE D = ‘Active’
AI Assistant
How do I sum column A only if B is “Paid”?

Use SUMIF:

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

Snippets

Library

+ New
MRR CalculationTEAM

Calculates monthly revenue across all subscriptions…

2h ago Toom
Regex: Email ValidPRIVATE
Yesterday

What our users 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.

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!