Monitor work quality and deadlines

I need the quality tracking sheet updated so the week’s task status is visible to supervisors. Add the late tasks for July 12–18, assign responsible person Marcus Hall, mark expected completion July 22, and update the on‑time percentage. After you do that, check conditional formatting so late tasks really show red before I send it to Operations at noon.

Before this goes to Operations, make the quality view easy to scan. Bring the on‑time percentage and number of late tasks to the top, make responsible owners clickable, flag any tasks that have missed two deadlines, and call out tasks that might block the monthly close so a manager can triage quickly.

The dashboard now shows on‑time performance down from 94% to 80%, yet the task list has zero late flags. I can't tell if the summary formula is pulling from the wrong range, a helper sheet is stale, or someone changed the deadline column format. Which diagnosis is most likely and what immediate step fixes the mismatch so I can explain to Operations?

Quarter after quarter we spend hours reconciling why the dashboard on‑time KPI and the task list disagree. That wastes managers' time and undermines deadline credibility. What permanent sheet design or entry habit would eliminate these reconciliation fires and keep the KPI and details in sync?