Project Portfolio template
Portfolios, projects, and risks — budget and actuals roll up from projects to portfolios, variance formulas flag overruns, and status colors carry through a board and timeline.
Tables
Portfolios
Portfolio, Owner, Description, Projects, Project count, Total budget, Total actual, Avg progress %, Business unit, Executive sponsor, Annual budget, Committed, Target benefit, Benefit type and 4 more
Projects
Project, Portfolio, Status, Health, Owner, Start, Finish, Budget, Actual cost, Progress %, Variance, Variance %, Schedule flag, Risks and 13 more
Risks
Risk, Project, Category, Status, Owner, Probability %, Impact (€), Exposure (€), Identified, Mitigation, Risk #, Project record, Project owner, Raised on and 4 more
Views
- Projects by status (grid)
- Health board (kanban)
- Portfolio timeline (timeline)
- Open risks (grid)
- Portfolio overview (grid)
Forms
- Report a risk
Automations
- Notify on new risk
- Escalate project changes to the PMO
- New record in “Projects”
- “Projects” reached “Completed”
- “Risks” reached “Closed”
- Daily sweep — still open in “Projects”
- “Escalated” was ticked in “Risks”
- Large value in “Budget”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.