Global @@variables
Define exchange rates, tax rates, period boundaries, allocation percentages once. Use them in formulas by name. Change the value once and every formula that referenced it updates.
Use case
Survive month-end closewithout rewriting the same formulas.
Close week is the same workbook every month, the same FX conversion, the same waterfall, the same accruals — re-derived from scratch by whoever is on rotation. Formula Foundry stores the patterns once and lets you flip a single @@variable to recalc the model.
Trial days only count when you actually open the add-on. No credit card.
How it works
Three habits that turn close week into close day.
Replace constants with @@variables
FX rate, target margin, allocation %. Define each as a global @@variable; every formula that referenced the hard-coded number now reads from one place. Updating the rate updates 500 cells at once.
Save the patterns to snippets
Your quarterly waterfall, your accrual formula, your variance-vs-budget call — all named, all stored, all one click to insert into next month's workbook.
Share the library with the team
On Pro and Business, the snippet library and variables are shared so the analyst on rotation isn't reverse-engineering last month's formula. Everyone uses the same vetted version.
What makes close faster
The pieces that turn re-derivation into reuse.
Shared snippet library
Your team's vetted formulas — the waterfall, the FX conversion, the variance-vs-budget calc — saved once, named once, inserted into next month's workbook by anyone on the team.
Multi-line editor for the gnarly ones
Accrual formulas have a tendency to grow until they're 300 characters of nested SUMIFS. The multi-line editor with indentation makes them maintainable instead of throwaway.
Centralized billing and invites
On Pro, anyone on your @company domain gets access on first sign-in — no procurement cycle. One invoice for the whole finance team, prorated as you add seats.
See it in action
Variables — change one, recalc the model.
Got questions?
Close FAQs
- Variables and snippets are on every plan. Shared snippet libraries — the team-wide standardization piece — kick in on Pro. Business adds SSO and a dedicated account manager but isn't required to standardize the formulas your finance team uses every month.
- The cells keep the resolved values they computed while the add-on was active — your numbers don't disappear. You lose the ability to edit or recalc through Formula Foundry until you're on a paid plan, but the existing formulas stay valid because they're standard Sheets / Excel formulas under the hood.
- Variables are per-workbook today; snippets sync across the workbooks of an account. So the waterfall pattern you saved as a snippet is one click away in next month's workbook even though it's a fresh file. Cross-workbook variables are on the roadmap; ask if your close depends on it.
- Most teams seed the variable list and a starter snippet library in an afternoon, then accrue more snippets each month as people notice patterns they re-derive. The standardization payoff compounds — month one is just installing; month three is when nobody is reverse-engineering last quarter's formulas.
Make next close shorter
Stop re-deriving the same formulas every month.
Install Formula Foundry, set up your team's variables and snippets once, and reclaim the days you spent rebuilding the workbook.