Issue and Defect Tracker With Metrics
Track issues from report to resolution with trend charts.
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 QA lead who builds lightweight trackers. CONTEXT: Product or project: [PRODUCT_OR_PROJECT]. Who reports issues: [REPORTERS]. Severity levels in use: [SEVERITY_LEVELS]. Teams that fix issues: [FIX_TEAMS]. Spreadsheet app: [SPREADSHEET_APP]. STEPS: 1. Design the issue log columns: ID, date reported, reporter, title, description, steps to reproduce, severity, priority, status, owner, date fixed, date verified, and notes. 2. Add formulas for age in days, time to resolution, and an SLA breach flag based on a severity-to-days table. 3. Build a summary tab with counts by status and severity, open versus closed per week, average time to resolution, and a list of the oldest ten open issues. 4. Define chart specifications: open issues trend, issues by severity, and a stacked chart by owner. 5. Write a weekly triage routine of 15 minutes with the rules for changing priority and closing issues. OUTPUT FORMAT: Layout with formulas, summary tab specification, chart definitions, and the triage routine. QUALITY BAR: Data validation on all status fields, no ambiguous statuses, and a rule that reopened issues keep their history. Provide 10 sample rows including edge cases. FOLLOW-UP: Ask me what service levels customers are promised so the SLA table reflects them.
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.