Automated Project Tracker with Risk Alerts

Overview

Most project boards start simple and get messy fast. Timelines drift because nobody remembers to update the parent when a phase slips. Budget overruns sneak up because the formula column is there but nobody watches it. And when a task hits a problem state, it sits unnoticed until the next stand-up.

This template solves all three problems with Community Cookbook automations. Parent timelines update themselves from subitem dates. Budget alerts fire the moment spend crosses your threshold. And any problem status — Blocked, On Hold, or Delayed — triggers a single notification to the right person.

Who This Template Is For

• Project managers tracking multiple deliverables with phases and milestones
• PMO leads who need portfolio-level visibility without manual data entry
• Agency teams managing client projects with budget constraints
• Any team where timeline accuracy and early risk detection matter

Board Structure

Groups

Organise your board with these groups:

• Active Projects — currently in progress
• At Risk — flagged by budget or status automations (items move here automatically or manually)
• Completed — finished projects (archive quarterly)
• Templates — a template item with pre-built subitems to duplicate for new projects

Columns

Subitems (Phases Per Project)

Each parent project gets subitems representing phases:

Each subitem has: Status (Not Started, In Progress, Blocked, On Hold, Delayed, Complete), Timeline (phase start and end dates), and Owner (phase lead).

Setting Up the Automations

Automation 1: Auto-Sync Parent Timelines

This uses the Sync Parent Dates from Subitem Timelines recipe.

What it does: Whenever a subitem timeline changes — a phase starts late, runs long, or finishes early — the parent project's Timeline, Start Date, and End Date columns update automatically to reflect the real range across all phases.

How to set it up:

1. Open the Automations Centre on your project board
2. Search for Community Cookbook recipes
3. Select: Roll up subitem timelines to the parent item
4. Map the subitem Timeline column to the parent Timeline, Start Date, and End Date columns
5. Activate

Now your Gantt view always shows the truth. When the design phase slips by a week, the parent project's timeline extends automatically. No more stale dates.

Automation 2: Budget Threshold Alerts

This uses the Formula Column Threshold Trigger.

What it does: When the Budget Used % formula crosses your threshold (e.g., 80%), the automation fires. You can use this to change the status to "At Risk", notify the project owner, or both.

How to set it up:

1. Open the Automations Centre
2. Search for Community Cookbook recipes
3. Select: When a numeric formula column goes above or below a number
4. Choose the Budget Used % formula column
5. Set the threshold to 80 (or whatever percentage makes sense for your team)
6. Set the action to change Status to At Risk and notify the Owner

Consider setting up two thresholds: 80% as a warning (notify) and 100% as critical (change status + escalate to leadership).

Automation 3: Problem Status Notifications

This uses the OR Status Trigger.

What it does: When any subitem's status changes to Blocked, On Hold, or Delayed, one automation fires to notify the project owner. Instead of three separate automations for three problem statuses, the OR trigger handles all of them.

How to set it up:

1. Open the Automations Centre
2. Search for Community Cookbook recipes
3. Select: When a column matches any of these values
4. Set the values to: Blocked, On Hold, Delayed
5. Set the action to notify the Owner on the parent item

This catches problems the moment they happen — not days later at the next status meeting.

Tips and Variations

• Multiple budget thresholds: Set up separate Formula Threshold Triggers at 50%, 80%, and 100% for progressive alerts. The 50% mark is a "halfway check", 80% is the warning, and 100% triggers escalation.
• Client-facing view: Create a filtered board view that hides internal columns (Budget, Spent) and shows only Status, Timeline, and progress — share this with clients.
• Dependency tracking: Add a Connect Boards column to link dependent projects. Use the Update Status in Connected Board recipe to cascade delays automatically.
• Resource allocation: Add a "Team Size" numbers column to subitems and a formula on the parent that sums them — see total resource allocation per project at a glance.
• Weekly digest: Add a native monday.com automation to email the project portfolio summary every Monday morning to leadership.

What You Will Need

• A monday.com account (Standard plan or above)
• Community Cookbook installed from the monday.com marketplace
• A board with Timeline and Formula columns enabled
• About 20 minutes for initial setup

Frequently Asked Questions

Can I use this with existing project boards?+

What if my projects don't use subitems?+

Does the budget formula update in real-time?+

Can I set different thresholds for different projects?+

How does this work with monday.com's native timeline features?+