Spreadsheets

Project Gantt Chart Builder

A simple project management tracker with automatic end-date calculations.

Updated: January 26, 2026

What does this AI prompt do?

This AI prompt helps UK SMEs by providing a ready-to-use template for a simple project management tracker with automatic end-date calculations.. Simply copy the template below, customize the variables for your business, and paste into any AI tool like ChatGPT or Claude.

AI Prompt Template

Act as a specialist consultant.

Here is the improved business prompt template, maintaining the exact structure while maximizing clarity, persuasiveness, and expected results:

**Objective:** I require a highly functional, streamlined Gantt Chart and Project Tracker built exclusively in **Google Sheets** tailored for a **[Project Type | text]**. This tool must ensure immediate clarity on project timelines and progress.

**Mandatory Columns (Ensure pristine data integrity):** Task ID, Task Name, Owner, Start Date, Duration (Days), End Date, Status.

**Required Output Specifications:**
1. **Contextual Task Examples:** Provide 5-7 *specific, high-impact* task examples directly relevant to the defined **[Project Type]**.
2. **Automated Calculation Formula:** Include the precise, robust formula required for the 'End Date' column to automatically calculate based on the 'Start Date' and 'Duration (Days)' inputs.
3. **Visual Progress Indicators:** Detail step-by-step instructions on implementing **Conditional Formatting** within the 'Status' column to visually represent progress instantly: **Red (Not Started/At Risk), Amber (In Progress), Green (Completed).**

How to use this prompt:

  1. Copy the template above
  2. Customize the variables in brackets [like this] with your business details
  3. Paste into ChatGPT, Claude, or your preferred AI tool
  4. Get professional results in minutes

Why this works:

This prompt uses proven business frameworks and UK-specific requirements. It's designed to give you professional results that comply with local regulations and industry best practices.

Browse More AI Prompts →