Projects template
Issue and bug tracker
Log bugs and requests with severity, status and assignee. Ages count up live and a summary matrix shows open work by severity.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Issues
42 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 169 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Live dates
- Frozen headers
- 1 chart
A look at the Issues sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Issue tracker | |||||||
| 2 | Leave Closed blank while an issue is open; Age counts days until it closes. | |||||||
| 3 | OPEN | CRITICAL OPEN | AVG AGE (OPEN) | CLOSED THIS MONTH | ||||
| 4 | 14 | 1 | 15.8 | 2 | ||||
| 5 | ||||||||
| 6 | ID | Title | Type | Severity | Status | Assignee | Opened | Closed |
| 7 | BUG-101 | Checkout button unresponsive on small screens | Bug | Critical | In progress | Morgan | 11/9/2026 | |
| 8 | BUG-102 | Password reset email arrives late | Bug | High | Open | Sam | 11/2/2026 | |
| 9 | FEA-103 | Export reports as CSV | Feature | Medium | In review | Riley | 10/20/2026 | |
| 10 | BUG-104 | Typo on pricing page | Bug | Low | Closed | Jordan | 10/28/2026 | 10/29/2026 |
| 11 | BUG-105 | Dashboard totals off by one day | Bug | High | Closed | Morgan | 10/14/2026 | 10/22/2026 |
| 12 | TSK-106 | Rotate API keys | Task | Medium | Open | Quinn | 11/5/2026 | |
- bugs
- issues
- qa
- software
- support
More projects templates
ProjectsProject trackerTrack every task with an owner, status, priority and due date. Overdue work turns red and the summary counts update as you go.
ProjectsGantt chartA weekly timeline where bars draw themselves from each task start and end date. The current week is highlighted and progress shades the bar.
ProjectsProduct roadmapList initiatives once and see them laid out by lane and quarter on a board that builds itself. Capacity checks flag quarters that are overbooked.
ProjectsRisk registerScore each risk by likelihood and impact, assign an owner and a response. A 5 by 5 heat map counts where the risks sit.
Start your issue and bug tracker now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.