Shared Google Sheets Log - For Small Projects or Sub-Contractors
How to Create a Construction Document Control Log in Google Sheets
Organizing construction documents effectively is crucial for any project. In this guide, we will walk through how to create a construction document control log in Google Sheets, which can be shared online for easy collaboration. Let’s go through the step-by-step process to build a structured, interactive, and shareable document control log.
Step 1: Set Up Your Google Sheet
| Action | Description |
|---|---|
| Create a New Google Sheet | Open Google Sheets and create a new spreadsheet. Title it "Construction Document Control Log". |
| Rename the First Tab | Rename the first sheet tab to something descriptive, like "Document Log". |
Step 2: Design Your Document Log Layout
Now we’ll create a layout with essential columns to track all document details. Here's a list of suggested columns and their purposes:
| Column Name | Description |
|---|---|
| Document ID | Unique identifier for each document. |
| Document Title | Brief title or description of the document. |
| Document Type | Type of document, such as drawings, contracts, or permits. |
| Version | Version number or date of the document. |
| Revision Date | The latest update date. |
| Author | Person who created the document. |
| Reviewer | Person who reviewed it. |
| Status | Current status, such as Draft, Under Review, Approved, or Rejected. |
| Remarks | Additional notes or comments about the document. |
| Link to Document | Hyperlink to the document stored online. |
Step 3: Create Dropdown Menus for Key Fields
Dropdown menus can ensure consistency. Here’s how to set them up:
1. Select the cells under columns like Status and Document Type.
2. Go to Data > Data Validation.
3. For Status, create a list such as Draft, Under Review, Approved, or Rejected.
4. For Document Type, add types like Drawings, Contracts, and Permits.
Step 4: Add Conditional Formatting for Status
Conditional formatting can visually differentiate document statuses.
1. Highlight the Status column.
2. Go to Format > Conditional Formatting.
3. Add rules based on each status (e.g., green for Approved, red for Rejected).
Step 5: Add Document Links
Store documents in a shared cloud location (like Google Drive) and paste the shareable link in the Link to Document column.
Step 6: Set Up Permissions for Collaboration
Allow specific team members to edit or view the document as needed:
1. Click on Share in the upper right corner of Google Sheets.
2. Choose who can access the log and set permissions (e.g., View, Comment, Edit).
Step 7: Automate Notifications for Updates (Optional)
Install add-ons to send notifications to stakeholders when changes are made:
1. Go to Add-ons and search for notification tools.
2. Set up alerts to email team members when new entries or updates are made.
Step 8: Test Your Log
Enter sample documents to ensure that everything works correctly. Verify the formatting, dropdowns, and links.
Step 9: Train Your Team on Using the Log
Brief your team on entering data consistently and updating the log regularly. This helps maintain organization and ensures everyone follows the same guidelines.
Step 10: Maintain and Review Regularly
Assign an administrator to review and update the log weekly to ensure accuracy and completeness.
Conclusion
By following these steps, you’ll have a well-organized, shareable construction document control log that allows for easy collaboration, streamlined access, and document tracking.
