Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 9 of 11 · 128 posts
INDEX MATCH vs XLOOKUP: Which Should You Use?
INDEX MATCH is flexible and widely understood. XLOOKUP is cleaner and easier to maintain. Here's how to choose between them for real spreadsheet work.
Introducing griddy-forge: Faster Document Ingestion for AI Spreadsheet Workflows
We published griddy-forge, a benchmark-driven document ingestion engine that replaces MarkItDown in Griddy. Up to 34x faster with higher extraction quality across PDFs, DOCX, spreadsheets, and CSV.
CRM Spreadsheet vs Sales Pipeline: What's the Difference?
A CRM spreadsheet tracks contacts and follow-up. A sales pipeline tracks active opportunities and what needs to close. Here's when to use each one and when you need both.
How to Use FILTER in Google Sheets
FILTER in Google Sheets returns only the rows that match your conditions. Here's the syntax, AND and OR examples, how to avoid #N/A, and how to use it for live working views.
How to Use VLOOKUP in Google Sheets
VLOOKUP in Google Sheets searches the first column of a range and returns a value from another column. Here's the syntax, exact-match examples, common errors, and when to use XLOOKUP instead.
How to Build a Freelancer Invoice Workflow in Excel
A freelancer invoice workflow is more than one invoice file. Here's how to set up a simple spreadsheet system for billing, due dates, payments, and expense context.
How to Track Small Business Expenses in a Spreadsheet
A small business expense sheet should do more than log transactions. Here's how to structure categories, receipts, and rollups so the spreadsheet is actually useful.
How to Use IFERROR in Excel
IFERROR replaces ugly spreadsheet errors with a cleaner fallback. Here's the syntax, the most common use cases, and when to avoid hiding real problems.
XLOOKUP vs VLOOKUP: Which Should You Use?
VLOOKUP is older and widely compatible. XLOOKUP is cleaner and more flexible. Here's when each one makes sense and how to choose between them.
Budget Tracker vs Expense Tracker: What's the Difference?
A budget tracker helps you plan spending before it happens. An expense tracker records what already happened. Here's when to use each one and when you need both.
How to Use COUNTIFS in Excel
COUNTIFS counts rows that match multiple conditions. Here's the syntax, examples for text, dates, blanks, and thresholds, plus the mistakes that break the count.
How to Use SUMIFS in Excel
SUMIFS adds values that meet multiple conditions. Here's the syntax, exact examples for text, dates, and thresholds, plus the mistakes that cause wrong totals.