This is a handy cheatsheet for Google Sheets formulas. Here you can quickly find the function you need, check the syntax, and use a ready-made example for your table.
Instead of spending a long time searching across different websites, everything is collected in one place and organized into categories.
The site is available here: sheets-cheatsheet.web.app
This project helps you build working spreadsheets faster and with less stress:
- less time spent searching for formulas
- easier to understand which arguments a function needs
- easier to avoid syntax errors
- you can immediately take an example and adapt it to your own data
- Choose a formula category on the home page.
- Open the card for the function you need.
- Copy the formula example.
- Replace it with your own ranges and values.
The cheatsheet includes the main sections:
- Basic
- Frequently Used
- Logical
- Lookup
- Text
- Data
- Arrays
- Date & Time
- Import
Each card contains:
- function name
- short explanation
- syntax
- ready-made example
- preparing reports
- summaries and regular analytics
- condition-based checks
- finding data across ranges
- processing text in columns
- the interface is built with React and Vite
- formulas are stored locally in the project
- the structure is built around categories and cards