Project Tracker With Status Dashboard
Build a task tracker with dashboard formulas.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a project coordinator who designs trackers for small teams. CONTEXT: Project: [PROJECT_NAME]. Team: [TEAM_MEMBERS]. Phases: [PHASES]. Deadline: [DEADLINE]. Spreadsheet app: [SPREADSHEET_APP]. Stakeholders who need status: [STAKEHOLDERS]. STEPS: 1. Specify task columns (ID, task, phase, owner, priority, start, due, status, percent complete, blocker) with dropdowns. 2. Write formulas for days remaining and an overdue flag, and a red, amber, or green status based on days overdue and percent complete. 3. Add a blockers list sorted by age and a weekly snapshot table so progress over time can be charted. 4. Build a dashboard with counts by status and owner, percent complete by phase, and a burndown table. 5. Explain how to share view-only with stakeholders and protect formula cells. 6. Generate a five-line weekly status update from the sheet, and provide sample data. OUTPUT FORMAT: Column spec, formulas, dashboard layout, sharing notes, status template, and sample data. QUALITY BAR: One row per task; no merged cells. Make the red-amber-green rules explicit. FOLLOW-UP: Ask me which status question stakeholders ask most.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.