Google Sheets invoice template: build one that tracks payment
Create a polished invoice, calculate totals correctly, and keep sent, due and overdue invoices visible in one dependable sheet.
Published July 26, 2026 · Updated July 27, 2026
AUTHORPhilis
Spreadsheet reviewer at SheetSteps
Philis writes and checks SheetSteps articles about data cleanup, charts, web imports and team workflows.
ARTICLES
Written by Philis
How to create a table in Google Sheets
Structure raw data with headers, types, filters and totals so sorting and formulas keep working as the sheet grows.
Published July 24, 2026 · Updated July 27, 2026
How to merge cells in Google Sheets—and when not to
Merge titles and presentation blocks safely while keeping tables sortable, filterable and formula-friendly.
Published July 22, 2026 · Updated July 27, 2026
How to use VLOOKUP in Google Sheets
Look up an ID, return the matching entry and fix the range, index and exact-match mistakes behind most VLOOKUP errors.
Published July 20, 2026 · Updated July 27, 2026
How to use IMPORTRANGE in Google Sheets
Pull a reliable range from another spreadsheet, grant access once and combine it with QUERY without creating a fragile chain.
Published July 18, 2026 · Updated July 27, 2026
How to use AI in Google Sheets for real work
Classify, extract, summarize and generate across rows while keeping prompts, outputs and costs predictable.
Published July 16, 2026 · Updated July 27, 2026
How to build a Google Sheets dashboard people can read
Turn a clean source table into a compact operating view with trustworthy KPIs, filters and charts.
Published July 14, 2026 · Updated July 27, 2026
Google Sheets formulas: the practical guide to writing them correctly
Learn the parts of a formula, how cell references behave and how to check a result before filling it down.
Published June 9, 2026 · Updated July 25, 2026
Google Sheets Gantt chart template: plan work on a real timeline
Turn tasks, owners, dates and status into a timeline that the team can update.
Published June 11, 2026 · Updated July 27, 2026
Google Sheets assignment tracker for classes and deadlines
Track classes, due dates, grades and overdue work in one compact student sheet.
Published June 13, 2026 · Updated July 25, 2026
How to search in Google Sheets
Find text, numbers and formulas in one sheet or the full workbook.
Published June 15, 2026 · Updated July 27, 2026
How to add a column in Google Sheets
Insert one or several columns without losing formulas, formatting or filters.
Published June 17, 2026 · Updated July 25, 2026
How to subtract in Google Sheets
Subtract cells, dates and fixed amounts with formulas that copy correctly.
Published June 19, 2026 · Updated July 27, 2026
Google Sheets percentage formulas for totals, growth and discounts
Calculate a share of total, percentage growth, discounts and percentage-point differences.
Published June 21, 2026 · Updated July 25, 2026
IMPORTHTML in Google Sheets: import tables and lists from a page
Pull a public HTML table or list into cells and fix the most common index mistakes.
Published June 23, 2026 · Updated July 27, 2026
How to use IMPORTXML in Google Sheets
Extract page titles, headings, links and table cells with a tested XPath.
Published June 9, 2026 · Updated July 25, 2026
Google Sheets conditional formatting not working: 8 checks
Repair rule ranges, custom formulas, date checks and rule order when cells do not format.
Published June 11, 2026 · Updated July 27, 2026
Google Sheets SUM that ignores errors
Total a range containing errors without deleting the source rows.
Published June 13, 2026 · Updated July 25, 2026
How to make a dropdown in Google Sheets
Create a fixed list, set invalid-data behavior and apply it to future rows.
Published June 15, 2026 · Updated July 27, 2026
How to filter in Google Sheets
Show only matching rows, save personal filter views and avoid changing what teammates see.
Published June 17, 2026 · Updated July 25, 2026
SUMIFS in Google Sheets: sum with several conditions
Total entries by date, owner, status or category with aligned ranges.
Published June 19, 2026 · Updated July 27, 2026
XLOOKUP in Google Sheets: cleaner exact-match lookups
Look up IDs, return entries from either side and set a clear not-found result.
Published June 21, 2026 · Updated July 25, 2026
Google Sheets inventory template with reorder warnings
Track stock, unit cost, reorder points and incoming quantities in one file.
Published June 23, 2026 · Updated July 27, 2026
Loan amortization schedule in Google Sheets
Split each payment into interest and principal and track the remaining balance.
Published June 9, 2026 · Updated July 25, 2026
Google Sheets content calendar for planning and publishing
Plan titles, channels, owners, dates and production status in one schedule.
Published June 11, 2026 · Updated July 27, 2026