Sheet Formulas exists because the rest of the internet still treats Google Sheets like a poor cousin to Excel. Search for almost any formula and the first ten results will be Excel tutorials with a half-hearted “Google Sheets is similar” paragraph stapled to the end. We did not love that, so we built this instead.
Who this is for
If you opened a Google Sheet because that is what your team uses, and now you need QUERY, ARRAYFORMULA, or IMPORTRANGE to do the actual work, this site is for you. We assume you are comfortable in a browser, that you do not have a copy of Excel installed, and that you would rather learn the Sheets way than translate from somebody else's. Every tutorial here is written and tested in Google Sheets first.
How the tutorials are structured
Every formula gets the same treatment: a short intro that frames the problem, a syntax breakdown that walks through the arguments one by one, a step-by-step walkthrough, two or three real example use cases, a list of the small mistakes that quietly break the formula in production sheets, and a set of related functions to explore next. The shape is consistent because we have found it is the fastest way for somebody to land on a page, get the answer, and get out — and also the easiest format to come back to weeks later when you have forgotten the syntax.
Where the data comes from
The formula list is seeded from the official Google Sheets function reference (support.google.com/docs/table/25273) at build time. We then layer our own writing, examples, and gotchas on top of each entry. If a formula is missing or wrong, please tell us — see the contact page for the best way to reach us.
What is intentionally not here
We do not cover Apps Script in depth, we do not write Excel-versus-Sheets comparisons, and we do not pad articles with "in this article you will learn" preludes. The goal is the smallest article that actually teaches the thing — not the longest one that ranks well.
Independence
Sheet Formulas is independent and is not affiliated with Google. Google Sheets™ is a trademark of Google LLC. The site is supported by tasteful display advertising — see the privacy page for the full story on what that means for your data.