Vact Airtable for Project Tracking: A PM's Guide to Relational Databases
Airtable is a spreadsheet-database hybrid that lets non-technical users build relational data systems with a spreadsheet-like interface. For project managers who have outgrown Google Sheets but do not need the complexity of dedicated PM tools, Airtable occupies a productive middle ground.
Airtable for Project Tracking
Airtable looks like a spreadsheet but behaves like a database. Each row is a record, each column is a field with a defined type (text, number, date, single select, linked record), and tables can reference each other through relationships. This means you can build a project tracker where tasks link to team members, milestones link to tasks, and risks link to milestones — all without writing a line of code.
Pricing
- Free: Unlimited bases, limited records per base, basic attachments
- Team: Paid per seat — more records, more storage, Gantt and Timeline views
- Business: Higher per-seat cost — larger record limits, advanced automations, admin controls
- Enterprise: Custom pricing — advanced security, audit logs, SAML SSO
Check Airtable’s website for current pricing.
The record limit on the free tier is the main constraint. A project with 200 tasks, 30 team members, 50 risks, and 100 meeting items hits 1,000 quickly across multiple tables. Most active PM use requires the Team plan.
Building a Project Tracker
Base Structure
Create a single base (Airtable’s term for a database) per project or per portfolio. Within the base, create tables for each entity:
Tasks table. Fields: Task Name, Description, Status (single select: Backlog, To Do, In Progress, In Review, Done), Priority (single select: P0, P1, P2, P3), Owner (linked to People table), Due Date, Sprint (linked to Sprints table), Story Points (number), Notes (long text).
People table. Fields: Name, Role, Email, Team, Availability (percentage). Link to Tasks table shows each person’s assigned work.
Sprints table. Fields: Sprint Name, Start Date, End Date, Goal, Status. Link to Tasks table shows all tasks in each sprint. Rollup fields calculate total story points planned and completed.
Milestones table. Fields: Milestone Name, Target Date, Status, Description. Link to Tasks table shows which tasks roll up to each milestone. Useful for milestone planning.
Risks table. Fields: Risk Description, Probability (single select: 1-5), Impact (single select: 1-5), Score (formula: Probability x Impact), Owner (linked to People), Mitigation, Status. This serves as your risk register.
Linked Records: The Key Feature
The power of Airtable is linked records. When you link a task to a person, you can then:
- View all tasks assigned to a specific person from the People table
- Use rollup fields to count how many tasks each person has in each status
- Create a filtered view showing overloaded team members
This relational capability is what separates Airtable from spreadsheets and makes it competitive with dedicated PM tools for tracking purposes.
Views: Multiple Perspectives on the Same Data
Every table supports multiple views. The same Tasks table can be displayed as:
Grid view. The default spreadsheet-like view. Sort by priority, filter by sprint, group by status. Each team member can save their own filtered view showing only their assignments.
Kanban view. Group tasks by Status and drag them between columns. This replicates a Kanban board without needing a separate tool.
Calendar view. Display tasks on a calendar by due date. Useful for visualizing the week’s workload and identifying deadline clusters.
Gantt view (Team plan). A timeline view that shows task durations and can display dependencies. Not as full-featured as Microsoft Project or Smartsheet, but adequate for straightforward scheduling.
Gallery view. Card-based display useful for visual content like design assets or deliverable previews.
Form view. Create input forms that add records to the table. Use this for project intake, bug reports, or retrospective feedback collection — the same function as Google Forms but feeding directly into your project data.
Automations
Airtable’s built-in automations trigger actions based on record changes:
- When Status changes to “Done”: Send a Slack notification to the project channel
- When Due Date is tomorrow: Send an email reminder to the task owner
- When a new record is created via form: Assign it to the triage owner and set status to “New”
- On a schedule: Generate a weekly summary of completed tasks and post to Slack
Automations on the Team plan support up to 25,000 runs per month. For more complex workflows, connect Airtable to Zapier or Make for cross-tool automation.
Templates Worth Starting From
Airtable’s template gallery includes PM-specific starting points:
- Project Tracker — Basic task management with status, priority, and owner fields
- Product Launch — Tasks organized by launch phase with a timeline view
- Bug Tracker — Issue tracking with severity, reproduction steps, and resolution status
- Content Calendar — For marketing project managers managing editorial schedules
Templates are starting points, not finished solutions. Plan to spend 2-3 hours customizing fields, views, and automations to match your team’s actual workflow.
Airtable vs Dedicated PM Tools
| Capability | Airtable | Jira | Asana | Monday.com |
|---|---|---|---|---|
| Custom data models | Excellent | Limited | Limited | Good |
| Sprint management | Manual setup | Native | Native | Plugin |
| Dependency tracking | Basic (Gantt) | Full | Full | Full |
| Reporting | Custom (rollups/formulas) | JQL + dashboards | Native dashboards | Native dashboards |
| Learning curve | Medium | High | Low | Low |
| Non-PM use cases | Excellent | Poor | Limited | Good |
Choose Airtable when your project tracking needs are unique and do not fit the assumptions of off-the-shelf PM tools. If your workflow matches standard Scrum or Kanban, a dedicated tool like Jira or Linear will require less setup.
Limitations
Performance. Large bases (10,000+ records with many linked fields and rollups) can slow down noticeably. Airtable is not built for the scale that enterprise PM tools handle.
Permissions. Granular permissions (field-level or record-level access) are limited compared to enterprise tools. On lower tiers, it is all-or-nothing table access.
No native resource management. Tracking resource allocation requires custom views and rollup formulas. Dedicated tools handle this natively.
No built-in time tracking. You will need an external time tracking tool integrated via automation or Zapier.
Airtable shines when your project data model is custom, your team is comfortable building their own views, and the project does not need the ceremony of a full PM platform. It is the duct tape of project management tools — flexible enough to build almost anything, constrained enough to stay manageable.