Skip to content
The Foundry Blog

Sharper formulas. Cleaner sheets.

Insights, tutorials, and updates from the team building the future of spreadsheet development.

A knotted rope partly untied and laid straight
6 min read

How to read someone else's complex Excel formula without breaking it

Inherited a formula that fills the whole formula bar? Split it into lines, step through it, and check four hidden traps before you change anything.

An open pocket watch revealing the gears that make it run, standing for seeing the formulas behind a spreadsheet
7 min read

How to show all formulas in Google Sheets at once: 5 simple ways

Switch every cell from result to formula in seconds, then learn five ways to read formulas and fix cells that show formula text instead of an answer.

Padlock on one toolbox beside an open toolbox, showing how to lock formulas while leaving input cells open
7 min read

How to lock formulas in Google Sheets for other users: a critical step

Protect formula cells, leave input cells open, test the lock with a second account, and flag any formula that gets overwritten anyway.

Nesting dolls stepping down to the right, picturing how to indent nested IF formulas in Excel
6 min read

How to indent nested IF formulas in Excel and stop guessing

A long nested IF is hard to read on one line. Add line breaks and indents in the formula bar so each condition and result lines up, and order mistakes show up fast.

Laptop showing a spreadsheet with one highlighted input cell beside a column of formula results
6 min read

Practical: how to change one cell and update all formulas in Excel

Put a value in one input cell, point your formulas at it, and know what to check when Excel refuses to recalculate.

Person holding a phone with a spreadsheet column of numbers on a desk
6 min read

How to sum a column in Google Sheets mobile on iPhone: smart tips

Get a total from your phone in two ways, a quick tap-and-read total and a SUM formula, then learn the checks that catch text numbers, hidden rows and short ranges.

Person working on a laptop spreadsheet to automate Google Sheets tasks
7 min read

How to automate Google Sheets: why you may not need to code

Most repetitive spreadsheet work needs a formula, a macro, or a simple trigger, not a big script. Here is how to choose and set up each method.

Spreadsheet on a laptop with one highlighted input cell
6 min read

How to use the same value in multiple formulas in Google Sheets

Store a rate or threshold in one cell, point every formula at it, and update hundreds of results at once. Here are four ways to do it and the mistakes to avoid.

Laptop with a spreadsheet beside a calculator on a desk
6 min read

Don't hardcode: how to store a tax rate for formulas in Google Sheets

Typing 0.08 into hundreds of formulas invites a missed update. Keep the rate in one named cell, then add lookups for locations and effective dates.

Browse all articles