Operations Dashboard

Welcome, Nooch

Enter jobs first — everything else pulls from there.

📋Enter a Job Submit a new job on your phone or at your desk using the quick entry form. Open Form → 📊Master Sheet Open the full job tracker — Jobs, Scheduler, Weekly View, and Payouts all in one place. Open Sheet → 🗓️Scheduler Plan the day — assign Gabe's QC route and painter stop order for the week. Open Scheduler →

Quick Workflow Reference

01

Add a New Job

APhone: Open Google Form → fill in details → Submit
BPC: Master Sheet → Jobs tab → next empty row → fill white columns only
!Jobs must be entered here first — all other tabs pull from Jobs

02

Schedule QC + Painters

1Open Scheduler tab
2Pick week from dropdown in cell B1
3Triangle Tools → Refresh Scheduler
4Enter stop numbers in yellow cells
5Triangle Tools → Save Schedule to Jobs

03

View the Week's Jobs

1Open Weekly View tab
2Pick week from dropdown in cell B1
3Triangle Tools → Refresh Weekly View
!Read-only — edit only on the Jobs tab

04

View Painter Payouts

1Open PayoutSummary tab
2Triangle Tools → Refresh Payout Summary
!Re-run anytime jobs or statuses change

✓ Always Do

Pick Property, Unit Type, Painter from dropdowns — don't type freehand
Update Status in column H as jobs progress
Run Refresh before looking at any tab
Use Clear Selected Job to remove a job — never delete the row
Enter jobs starting from the next empty row going down

✗ Never Do

Sort the Jobs tab
Insert or delete rows on the Jobs tab
Type in dark gray columns — they calculate automatically
Rearrange or move columns
Click Yes on a "Heads up!" popup unless you're certain

Operations Dashboard

Welcome, Nooch

Enter jobs first — everything else pulls from there.

📋Enter a Job Submit a new job on your phone or at your desk using the quick entry form. Open Form → 📊Master Sheet Open the full job tracker — Jobs, Scheduler, Weekly View, and Payouts all in one place. Open Sheet → 🗓️Scheduler Plan the day — assign Gabe's QC route and painter stop order for the week. Open Scheduler →

Quick Workflow Reference

01

Add a New Job

APhone: Open Google Form → fill in details → Submit
BPC: Master Sheet → Jobs tab → next empty row → fill white columns only
!Jobs must be entered here first — all other tabs pull from Jobs

02

Schedule QC + Painters

1Open Scheduler tab
2Pick week from dropdown in cell B1
3Triangle Tools → Refresh Scheduler
4Enter stop numbers in yellow cells
5Triangle Tools → Save Schedule to Jobs

03

View the Week's Jobs

1Open Weekly View tab
2Pick week from dropdown in cell B1
3Triangle Tools → Refresh Weekly View
!Read-only — edit only on the Jobs tab

04

View Painter Payouts

1Open PayoutSummary tab
2Triangle Tools → Refresh Payout Summary
!Re-run anytime jobs or statuses change

✓ Always Do

Pick Property, Unit Type, Painter from dropdowns — don't type freehand
Update Status in column H as jobs progress
Run Refresh before looking at any tab
Use Clear Selected Job to remove a job — never delete the row
Enter jobs starting from the next empty row going down

✗ Never Do

Sort the Jobs tab
Insert or delete rows on the Jobs tab
Type in dark gray columns — they calculate automatically
Rearrange or move columns
Click Yes on a "Heads up!" popup unless you're certain