Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 1 of 11 · 128 posts
Google Sheets Concatenate
Use CONCATENATE, ampersands, and TEXTJOIN in Google Sheets to combine names, labels, IDs, addresses, notes, and review text cleanly.
Google Sheets Freeze Rows
Freeze rows in Google Sheets so headers, dates, owner names, and review labels stay visible while you scroll through large spreadsheets.
Google Sheets VLOOKUP From Another Sheet
Use VLOOKUP across tabs in Google Sheets to pull owner, stage, rate, client, or category details from a separate lookup table.
How to Sort in Google Sheets
Sort data in Google Sheets by date, status, owner, amount, or multiple columns without breaking the structure of your working spreadsheet.
How to Use ARRAYFORMULA in Google Sheets
Use ARRAYFORMULA in Google Sheets to apply one formula across an entire column, fill calculated fields, and avoid fragile copy-down formulas.
COUNTIF Not Counting Correctly in Excel
COUNTIF can miss rows when criteria, spaces, numbers, dates, or ranges do not match. Learn the common causes and clean fixes.
Google Sheets IF Statement
Use the IF statement in Google Sheets to return different values based on a condition, with practical examples for statuses, dates, and review flags.
How to Make a Pivot Table in Google Sheets
Create a pivot table in Google Sheets to summarize rows by category, owner, date, or status without rebuilding manual reports.
How to Use the INDIRECT Function in Excel
Use INDIRECT in Excel to turn text into a reference, with examples for sheet names, dynamic ranges, and common errors to avoid.
How to Use the OFFSET Function in Excel
Use OFFSET in Excel to return a range shifted from a starting cell, with examples for rolling windows, summaries, and safer alternatives.
How to Fix Circular References in Excel
A circular reference in Excel means a formula depends on itself. Learn how to find the loop, repair formulas, and avoid hidden total errors.
How to Fix the #NAME? Error in Excel
The #NAME? error in Excel means a formula contains text Excel does not recognize. Learn the common causes and clean fixes.