Project Tracker template
Projects, tasks, and people — with progress formulas, an overdue flag, task dependencies, and a board, timeline, and calendar over the same data.
Tables
Projects
Project, Status, Health, Owner, Start, Due, Budget, Spent, Budget left, Project code, Phase, Client, Sponsor, Tags and 12 more
Tasks
Task, Project, Status, Priority, Assignee, Start, Due, Estimate (h), Progress %, Depends on, Ticket, Project record, Project owner, Type and 9 more
People
Name, Role, Email, Phone, Capacity (h/wk), Rate, Load note, Skills, Timezone, Started, Available from, Utilisation, Contractor, Photo and 4 more
Views
- All tasks (grid)
- Board (kanban)
- Timeline (timeline)
- Calendar (calendar)
- Portfolio (grid)
Forms
- New task
Automations
- Notify on new task
- Ping the team channel on changes
- “Tasks” reached “Done”
- “Projects” reached “Done”
- Daily sweep — still open in “Tasks”
- “Contractor” was ticked in “People”
- Large value in “Estimate (h)”
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.