Snag List Format In Excel -

| Snag ID | Location | Item | Defect Description | Priority | Status | Assigned To | Date Identified | Target Fix Date | Date Fixed | Verified By | Remarks | |---------|----------|------|--------------------|----------|--------|--------------|----------------|----------------|------------|-------------|---------| | S-001 | Level 2 Hall | Light fixture | Flickering light | Medium | In Progress | Electrical Co. | 08-Apr-2026 | 15-Apr-2026 | | | Awaiting part | | S-002 | Kitchen | Countertop | Scratch on surface | High | Open | Carpentry | 09-Apr-2026 | 12-Apr-2026 | | | |

A "Status" column is the engine of the snag list. Using a dropdown menu with options like Outstanding, In Progress, Rectified, Closed, and N/A allows for instant visualization of the project's health. To enhance this, Excel’s "Conditional Formatting" tool can be employed. For example, cells containing "Outstanding" can be set to turn red, "In Progress" to yellow, and "Closed" to green. This visual cue allows a project manager to scan 500 rows and instantly know if the project is on track.

The core of the list is the description. A column titled "Description of Defect" should be sufficiently wide to allow for detail. However, to make the data sortable, it is helpful to have a separate column for "Discipline" or "Trade" (e.g., Electrical, Carpentry, Plumbing). By using Excel’s "Data Validation" feature to create a dropdown menu for the Trade column, the project manager can later filter the list to show only electrical faults, handing a concise sub-list to the electrician. snag list format in excel

Snag ID Location Item Defect Description Priority Status Assigned To Date Identified Target Fix Date Date Fixed Verified By Remarks S-001 Level 2 Hall Light fixture Flickering light Medium In Progress Electrical Co. 08-Apr-2026 15-Apr-2026 Awaiting part S-002 Kitchen Countertop Scratch on surface High Open Carpentry 09-Apr-2026 12-Apr-2026

The primary function of the snag list is tracking progress. The right side of the spreadsheet should be dedicated to the lifecycle of the repair. | Snag ID | Location | Item |

An effective Excel snag list requires a clear, tabular layout. You can download professional templates from providers like Smartsheet or ProjectManager to get started quickly.

Beyond simple data entry, Excel offers tools that transform a snag list into a management report. To enhance this, Excel’s "Conditional Formatting" tool can

Total Snags: =COUNTA(A:A)-1 Open Snags: =COUNTIF(F:F,"Open") High Priority Open: =COUNTIFS(E:E,"High",F:F,"Open") Completed: =COUNTIF(F:F,"Fixed") On-Time Fix Rate: =Completed / Total Fixed