From the outset, project management can seem like a simple framework for getting tasks done—that is, until it becomes incredibly complex. Competing deadlines, detailed deliverables, and budget approvals can quickly add up to a muddled workflow.
Conquering your core processes is the key to executing multiple projects at once, and ensuring that your team can handle scaling up its workload. With the right system, balancing team leads and remote contributors, reporting on project status and spend, and checking off action items on schedule can feel effortless.
Adding Airtable Blocks to your project management process can help you speed through capacity planning, make sure the dates and projects that matter most are always top of mind, and give stakeholders a window into your team's performance—without growing your to-do list. And anything that saves you a few minutes is another step toward hitting your project goals.
Here's your plan for putting this into action:
Focus on what's up next
Managing multiple projects, launch dates, and contributors can create a lot of noise. Zero in on your most important deadlines and projects with blocks that keep them front and center.
Never miss a deadline
Step 1: Make a list of projects, and a view of current ones.
If you don't already have one, make sure that your base has a table of projects, with details like due dates, owner, and status. Create a view in the table that's filtered down to incomplete projects—you'll want to use this to power both blocks.
Step 2: Add a summary block and a countdown block.
Step 3: Choose the dates you want to track.
For the summary block, select the incomplete view and choose the Summary option, then the field that holds due dates. Set the summary type to Earliest date.
In the countdown block, toggle the Date from view option and select the same view of incomplete projects. Make sure Earliest date is selected and check off the units you'd like to track.
Quickly reference current projects
Use the record list block to create an always-up-to-date list of open projects.
Step 1: Create a view showing your current projects.
If you don't already have one, create a view in the table that's filtered to show just the projects that are currently sitting in your pipeline.
Step 2: Add a record list block.
Next, choose the add a block option from the blocks menu, and add a record list block to your base.
Step 3: Configure the record list block.
From the dropdown menu in the record list block's settings, select the appropriate table and the view you created in Step 1. This detailed look at your list of records will stay current as projects move in and out of the view.
Balance workloads and time spend
Executing projects on time is all about fine-tuning your team's priorities. Fuel your strategy with quick insight into each contributor's overall workload, as well as the nitty-gritty of how they're spending their time.
Check team bandwidth and project status at a glance
Use the chart block to show the number of projects allocated to each team member, and see their current status.
Step 1: Add a chart block to your base.
Open up the blocks menu, click the add a block option, and add a new chart block to your base. With the chart block, you can make a bar chart, a line graph, or a scatter plot.
Step 2: Adjust the chart block to fit your needs.
Once you've added the chart block, you can tweak the settings to match your needs. Of these three types of graphs, a bar chart is best suited to comparing between different groups, so we suggest a bar chart for quickly seeing the number of projects assigned to each contributor. But of course, you can pick whichever type you want.
If you're doing a bar chart, we recommend that the X-axis be a collaborator or single select field showing who's in charge of the project. You can take it a step further, as above, by having the bar coloring indicate completion status. In the Y-axis section, select “Group by,” then a checkmark or single select field that corresponds to project status. In the example above, the “Stack” option is also toggled on to achieve this formatting.
Capture time-tracking data without leaving your base
Connect the time tracker block to relevant projects, and let team members easily report time spent as they work.
Step 1: Create a field for logging time tracked.
In a project or task table, make sure you have three field types in place: a collaborator field for project contributors, and a date field and duration field for capturing the session that contributor is tracking.
Step 2: Add a time tracker block.
In the blocks menu, select the add a block option, and add a time tracker block to your base. Point the settings toward the fields you just created.
Now when teammates are ready to log a session, they can simply hit the Start timer button and get to work!
Automate updates for stakeholders
If you're juggling multiple timelines, chances are you need to report on progress—and budget—to a range of interested parties. Blocks can generate slides and tables that are always in sync with your latest project status.
Instantly create up-to-date project decks
Set up the page designer block to quickly export the latest project statuses into polished slides ready to share with stakeholders.
Step 1: Add a page designer block.
Select the add a block option in the blocks menu, and add a new page designer block to your base. Make sure to pick the correct table and view. You should select the custom page size and input the dimensions that you'll need for your assets.
Step 2: Design your slide template.
Choose the pieces of project data you want to present in your deck. You can drag and drop elements onto the page, tweak fonts and colors, and otherwise adjust according to your aesthetics to make a great template page for your slides.
Step 3: Export your slides into a shareable PDF.
When you're ready to report on progress, use the print dialog to generate a PDF with your up-to-date deck.
Track budgets across clients and focus areas
Use the pivot table block to sum up project data, like the spread of client budgets over relevant categories, at a high level.
Step 1: Make a budget field.
If you don't already have one, make sure that your project table has a currency field that lists the budget for each record.
Step 2: Add a pivot table block.
Open up the blocks menu, click the add a block option, and add a pivot table block to your base. You can select your project table in the first settings field.
Step 3: Customize the table for your needs.
The view that you choose in the block settings will depend on which projects you'd like to analyze. If you're interested in breaking down all existing projects, you should select a master view; if you're interested in seeing budgets for only a subset of projects, like ones that are incomplete, you should select a view filtered down to just those records.
Above, projects are listed by client, and separated by category. To achieve this setup, select a field that show clients for your row grouping, and a field that indicates categories for your column grouping.
Keep tabs on virtual contributors and projects
Your project team needs to stay connected no matter where they're based. Host impromptu check-ins with a quick-access virtual meeting room—and keep key time zones in sight for referencing project deadlines.
Jump into e-meetings without leaving your base
Step 1: Add a Whereby or Google Hangouts block.
Set up the meeting room of your choice by heading to the blocks menu, clicking the add a block option, and choosing either the Whereby or Google Hangouts block.
Step 2: Share your meeting room address with external attendees.
Need to meet with a contributor who's not in your base? You can share your meeting room with outside stakeholders, and chat with them right inside your base.
For Whereby, you'll set a unique URL for your room that you can lock to uninvited guests. For Google Hangouts, you'll be prompted to login using your Google account, and can invite others directly from the room.
Make a dashboard of key time zones
Add multiple world clock blocks to display the local times in relevant time zones.
Step 1: Add a world clock block.
Choose the add a block option from the blocks menu, then add a world clock block to your base and select the city whose time zone you'd like to display.
Step 2: Customize the clock's time zone and display options.
You can toggle between digital and analog modes, as well as 12- and 24-hour time formatting. You can change the color of the graphic and apply a custom label if you like.
Can't get enough of Airtable Blocks? Sign up for our mailing list to get updated for each new block we launch!