Project Management System with Delay Alerts – Apps Script

A project management dashboard that chases deadlines instead of displaying them. Projects and their tasks sit in one place on Google Sheets, and the system emails people before a deadline and again once a project is running late — which is the part a spreadsheet can never do on its own.

What it does

Everything runs from a central dashboard: projects, their status and their deadlines, filtered dynamically so a manager can narrow to what they are responsible for. Task reminders go out by email automatically, and delay notifications fire on projects that have passed their date, so an overdue job announces itself rather than waiting to be noticed at a review meeting. Multi-currency support covers clients billed in different currencies, and user management with access control keeps people to their own part of the board.

Highlights

• Central project dashboard with dynamic filtering
• Deadline and delay tracking
• Automated task reminder emails
• Automated delay notifications on overdue projects
• Smart status updates
• Multi-currency support
• User management and access control

Who it is for

Agencies, consultants, contractors and small teams running several client projects at once, where the risk is not complexity but a deadline nobody looked at until it had passed.