Format Excel !!better!! — Snag List

: A place to link photos of the defect for visual clarity. How to Create Your Own in Excel

Visual cues help you spot problems instantly. You can set up rules so that rows change color based on the status. snag list format excel

Before we dive into the formatting, let’s align on the definition. A (often called a punch list in the US) is a document created during the final stages of a construction project or at the end of a defect liability period. It lists work that has not been completed to the agreed-upon standard or work that does not meet the specifications. : A place to link photos of the defect for visual clarity

: The specific contractor or person assigned to fix the issue. Before we dive into the formatting, let’s align

In the world of construction, property management, and interior fit-outs, the "snag list" (or punch list in North America) is both a necessity and a nightmare. It is the final barrier between a completed project and a satisfied client. However, when managed poorly—scribbled on notepads, lost in email threads, or tracked in inconsistent Word documents—the snag list becomes a liability.

| Column | Header Name | Purpose | | :--- | :--- | :--- | | | Item ID | A unique identifier (e.g., SN-001). Essential for referencing specific snags in emails or meetings. | | B | Location | Where is the defect? (e.g., "Living Room," "Floor 3," or "Zone A"). | | C | Element/Category | What type of snag is it? (e.g., Electrical, Plumbing, Joinery, Finishes). | | D | Description | A detailed explanation of the defect. Clear enough that a third party can understand it. | | E | Responsible Party | Who needs to fix it? (Name of the Contractor or Sub-contractor). | | F | Priority | How urgent is it? (High, Medium, Low, or Critical). | | G | Due Date | The deadline for rectification. | | H | Status | Is it Open, In Progress, or Closed? | | I | Photo Reference | A code linking to a photo file (e.g., "IMG_4021.jpg"). | | J | Comments/Notes | Updates on rectification or reasons for delay. |

(use data validation dropdown in Excel)