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.
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.