Google Sheets

Google Sheets: Build a Job Tracker That Totals Itself

A beginner Google Sheets walkthrough on real screens: freeze the header, make Status a drop-down, total each status with SUMIF, highlight finished-but-unbilled jobs and save a filter view for each crew. Free Google account.

Free
No sign-up
36 steps
~15 min

Start the free practiceStart practicingDo every step yourself in a practice copyHands-on, ~15 min, best on a computer

Google Sheets: Build a Job Tracker That Totals ItselfA beginner Google Sheets walkthrough on real screens: freeze the header, make Status a drop-down, total each status with SUMIF, highlight finished-but-unbilled jobs and save a filter view for each crew. Free Google account.This lesson needs JavaScript. You can read every step here: Google Sheets: Build a Job Tracker That Totals Itself: the step-by-step guide, or browse all free AI automation tutorials.Stepthrough is free AI training by Robert Breen · Ynteractive (AI automation consulting) · Services · Hire an n8n developer