Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 5 of 13 · 148 posts
Google Sheets COUNTIF
Use Google Sheets COUNTIF to count rows that match one condition, including statuses, categories, text, dates, and numeric thresholds.
Google Sheets Date Formulas
Use Google Sheets date formulas like TODAY, EDATE, EOMONTH, WORKDAY, and NETWORKDAYS for timelines, budgets, and schedules.
Google Sheets Remove Duplicates
Remove duplicates in Google Sheets with the built-in cleanup tool, UNIQUE formulas, and safer review steps for shared data.
How to Use XLOOKUP in Google Sheets
Use XLOOKUP in Google Sheets to return matching values from any direction, handle missing results, and avoid fragile VLOOKUP column indexes.
Budget Tracker vs Savings Tracker
A budget tracker controls monthly spending, while a savings tracker follows progress toward specific goals. Use both when planning and follow-through matter.
Google Sheets Dropdown List
Create a Google Sheets dropdown list with data validation, custom options, colors, ranges, and cleaner status fields for shared spreadsheets.
How to Build a Student Budget in a Spreadsheet
Create a student budget spreadsheet that separates income, fixed costs, flexible spending, school expenses, and savings.
Student Budget Planner Excel
Build a student budget planner in Excel that tracks income, rent, books, food, subscriptions, savings, and weekly spending room.
Employee Schedule Template Excel
Use an Excel employee schedule template to plan weekly shifts, coverage, hours, and PTO conflicts without rebuilding the rota from scratch.
How to Calculate Hours Worked in Excel
Calculate hours worked in Excel from start and end times, handle overnight shifts, and roll daily hours into weekly totals.
How to Make a Work Schedule in Excel
Build a weekly work schedule in Excel that shows shifts, hours, off days, and coverage gaps before the schedule goes out to the team.
How to Protect Cells in Excel
Protect cells in Excel so formulas, totals, and template structure stay safe while managers or teammates edit the fields they actually need.