Status rules, not manual updates
On track, at risk, and past due are calculated from days open against the target for that job. Nobody colors cells by hand.
This is a working version of the job tracking dashboard we build for shops and service companies. Filter it, search it, sort it, and flip it to TV mode to see what the shop floor screen looks like. The data is sample data, not a client's.
Sample data. Job numbers, customers, and dollar amounts are made up for this demo.
On track, at risk, and past due are calculated from days open against the target for that job. Nobody colors cells by hand.
Management sees the dashboard, the floor sees the TV board, and the crew works the tracker. All three read the same file.
The production version runs in Excel or Google Sheets with Office Scripts, Power Automate, or Python doing the repetitive parts.
Send us how you track work today. We will show you what this looks like with your stages, your customers, and your numbers.