Kpiloom

Google Sheets Project Dashboard Templates

A project dashboard shows which projects are on time and on budget, and how busy the team is. Pick your industry below to see a live preview of the Google Sheets version.

Choose your industry

KPIs in every project dashboard

KPIWhat it tells youFormula
Active projectsProjects currently in progress.COUNT of projects with status = Active
On-time projectsShare of projects on or ahead of schedule.Projects on schedule ÷ Active projects
Budget usedShare of approved budget already spent.Actual cost ÷ Budget
Billable hoursHours that can be charged to clients.SUM of hours where Billable = Yes
Team utilisationShare of available hours spent on project work.Logged project hours ÷ Available hours
Overdue tasksTasks past their due date and not done.COUNT of tasks where Due < Today and Status ≠ Done
Milestones hitMilestones completed on time.COUNT of milestones done by due date
Project marginProfit left after project costs.(Project revenue − Project cost) ÷ Project revenue