Griddy / Blog
Spreadsheet how-tos.
Step-by-step guides for Excel and Google Sheets formulas, data cleanup, charts, and more — and how Griddy handles each one in seconds.
Page 4 of 7 · 76 posts
How to Use IFS in Excel
IFS checks multiple conditions in order and returns the first matching result. Here's the syntax, a realistic status example, and the mistakes that cause the wrong label to appear.
How to Use NETWORKDAYS in Excel
NETWORKDAYS counts working days between two dates. Here's the syntax, a real project-planning example, how holidays work, and the mistakes that throw off the count.
How to Use the UNIQUE Function in Excel
UNIQUE returns distinct values or rows from a range. Here's the syntax, common examples, and how to use it to build cleaner review views from messy spreadsheet data.
How to Use WORKDAY in Excel
WORKDAY returns a future or past business date after a set number of working days. Here's the syntax, a project example, holiday handling, and the mistakes that shift deadlines.
How to Use XMATCH in Excel
XMATCH returns the position of a value in a range and improves on MATCH with cleaner exact matching, reverse search, and better flexibility. Here's how to use it.
How to Build a Sales Pipeline Spreadsheet
A sales pipeline spreadsheet should track active deals, stage, value, probability, and next move. Here's a practical structure for building one that stays useful.
How to Organize a CRM in Excel
A good Excel CRM is not just a contact list. Here's how to structure leads, owners, next follow-up dates, and status so the sheet stays useful.
How to Use INDEX MATCH in Google Sheets
INDEX MATCH in Google Sheets is a flexible lookup pattern that handles left lookups and survives inserted columns. Here's the syntax, examples, and when to use it.
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.