Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 8 of 11 · 128 posts
Best Team Status Fields for Project Trackers
A project tracker works better when status fields are simple, unambiguous, and tied to real review decisions. Here's a practical status set most teams can use.
Excel vs Google Sheets for Project Tracking
Excel is stronger for heavier models and structured reporting. Google Sheets is stronger for lightweight collaboration. Here's how to choose the right tool for project tracking.
Gantt Chart vs Project Tracker: What's the Difference?
A Gantt chart is built for timing and dependencies. A project tracker is built for ownership, status, and next action. Here's when to use each one and when you need both.
How to Build an OKR Tracker in a Spreadsheet
A useful OKR tracker should show objectives, key results, owners, progress, and confidence in one reviewable sheet. Here's a practical structure that stays usable.
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.