Million Dollar YearGet the free app

How to build a project management system in Airtable fast

By Max Warnault · 3 June 2024 · 6 min read

In short

To build a project management system in Airtable, create a new workspace, open Templates at the bottom left, pick Project management and click "Try this template". In under a minute you have project, task and delegation management in one place, with a task view, schedule, Kanban, roadmap, team insights and a team list. Then delete the sample projects and tasks, add your own projects and tasks, and assign each task an owner, a start date, a deadline and its predecessor.

Without a project management system, you lose track of which project you are working on, which task you need to delegate and what everyone on your team is doing next. Communication slips, productivity drops, and the business gets harder to scale.

I'll show you how to set up a project management system, a task management system and a delegation system in Airtable in less than five minutes. It all lives in one place, and it works whether you have a team or work alone.

How to create a project management system in Airtable

You don't need to build anything from scratch. Airtable has a template that does almost all of the work.

  1. Create an Airtable account if you don't have one.
  2. Create a new workspace. I simply called mine "workspace".
  3. Go to Templates, at the bottom left.
  4. Choose Project management.
  5. Click "Try this template".

In less than a minute you have your project management, your task management and your delegation system, all in one place, with all the features you will need. That's why I love Airtable: it's easy to use, and this template lets you get a lot done in a few minutes.

What the Airtable project management template includes

The template opens on an interface with several views. Each one answers a different question about your work.

My tasks

This view shows the tasks of the user who is logged in. In the sample, I could see three tasks to do and four already done.

Tasks by project

Here you see each project with its tasks. Every project shows a percentage done, calculated from the number of tasks completed. A project with every task finished shows as done. A project where one task out of ten is complete shows 10%.

You can edit any task from here. For example, I took a task to design a 3D model, assigned it to a team member, and changed its start date and end date.

Schedule

The schedule is a timeline of the next tasks and their dependencies. In the sample, one task, creating video tutorials, can only start after another, building a progress tracking system, is done. You can pick a project and see where you are, what has been done, what is in progress and what still needs to be done, all shown by colour.

Kanban

The Kanban is organised by project. In a sample project, the concept stage is done, and the team is now working with beta testers for feedback, a task assigned to one team member.

Roadmap

The roadmap shows when projects run. In the sample, January is a busy month with many projects at once, and from February they spread out more. This lets you review the priorities, and the projects and tasks you and your team need to work on.

Management insights

This view gives you the overall picture:

  • The percentage of tasks completed.
  • The percentage of tasks overdue, which you can click to see which tasks are late based on their end dates.
  • How many tasks each person has assigned.
  • A status breakdown. The sample showed 70% to do, 11% in progress and 19% done.
  • A utilization breakdown, based on tasks and days of work, showing how loaded each person is. In the sample, one person was working on three tasks that would take four work days.

The per-person count is where delegation gets easier. If one person has too much on their plate, you can give more to someone else and spread the tasks out.

Team

This view lists everyone on your team, full-time people and contractors. You can edit them right there, send them a message in Slack, and add someone new. You can also add a new project from the interface (standard or small), with a picture if you want one.

The data side of the Airtable template

Behind the interface sits the data. The getting started page lists every view: my tasks, all tasks broken down by project, the schedule showing the order tasks will be worked on, the Kanban, the roadmap for long-term work and outcomes by project, and the insights for managing the team.

To work with the data, go into the tables:

  • People: where you manually edit your team, the tasks they are assigned, their role and whether they are a contractor or full-time.
  • Projects: where you keep only the projects you really have. If you have three projects, keep those and delete the rest.
  • Tasks: where you can remove every task without a project.

My recommendation is to delete all the sample tasks and start from scratch.

How to set up your own projects and tasks in Airtable

Once the sample data is gone, add your real work.

  1. Add the name of each project. If you are building a community, add "Community". If you have a software, type its name. You might add "Marketing" too.
  2. If you work solo, add a project such as "Personal tasks". The system works for a solopreneur as well as for a team.
  3. Go back to the interface. A new project shows no tasks yet, so add one. I added "Create a welcome post".
  4. Set the status to "to do", assign it to a person, set the start date to today and the deadline to Friday.
  5. Add the next task, "Invite members", with the same owner and the same Friday deadline.
  6. Link the tasks. In the predecessor field, set "Create welcome post" as the predecessor of "Invite members", because the welcome post has to exist before you invite anyone.

Open the schedule and go to today, and you'll see the order: the welcome post is created today in one day, and inviting members starts the day after. From there you keep going, and you can always see which projects you're working on, which tasks belong to them and when each one is due.

This is the kind of system that brings clarity to a business. At Million Dollar Year, systemizing the operations is one of the three stages of the work, and a single place for projects, tasks and owners is a simple place to start. It helps you be more productive, by yourself or with a team.

Key takeaways

  • Start from Airtable's Project management template instead of building your own base from scratch.
  • Delete all the sample projects and tasks, then add only the projects you really have.
  • Give every task a status, an owner, a start date and a deadline.
  • Use the predecessor field so the schedule shows which task must be done before the next one starts.
  • Check the insights view for tasks per person and overdue tasks, and move work from overloaded people to others.
  • If you work alone, add a "Personal tasks" project and use the same system.

Questions and answers

How do I create a project management system in Airtable?

Create a workspace, go to Templates at the bottom left, choose Project management and click "Try this template". In less than a minute you have project, task and delegation management in one place. Then replace the sample data with your own projects and tasks.

What views does the Airtable project management template include?

It includes my tasks, tasks by project with a percentage done, a schedule timeline with dependencies, a Kanban, a roadmap, management insights and a team list. The insights show completed and overdue tasks, tasks per person, a status breakdown and a utilization breakdown.

Should I keep the sample data in the Airtable template?

I recommend deleting all the sample tasks and starting from scratch. Keep only your real projects in the projects table and edit the people table with your own team, their roles and whether they are contractors or full-time.

How do I set task dependencies in Airtable?

Use the predecessor field on a task to link it to the task that must come first. For example, set "Create welcome post" as the predecessor of "Invite members". The schedule then shows the welcome post today and inviting members the day after.

Can I use an Airtable project management system as a solopreneur?

Yes. Add your projects, such as a community, a software or marketing, and add a "Personal tasks" project. You get the same clarity on what to work on and when, without a team.

For 6-figure coaches and agencies

Build a million dollar business, solo, with systems and AI.

Start with the free app: your year planned down to today, your numbers in one place, and exactly what your goal takes.

Get the free app

Free · No card · On the web and on your iPhone

Keep reading