Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Aug 18, 2020 11:49 AM
Hi All,
I am trying to build out an automated-ish roadmap and resource planning base that will help schedule features based on sprint data and resource availability. I used this base as a starting point: I started with this resource planning base: Resource Planning - Airtable Universe
Here is the google sheet that I currently use to auto-schedule our roadmap: Roadmap Planning Example - Google Sheets The sheet doesn’t account for headcount, but it is easy to eyeball and pencil in. I’d like to use Airtable to autoschedule the roadmap based on feature complexity and then layer in the resource allocation to match.
The problem that I have is
The base consists of three parts:
Roadmap - contains features and the allocation record that ties the feature to the engineer(s) working on the feature. Start and end dates of the features are driven based on the associated sprints.
Team - All available engineers and associated feature and sprints they are assigned to based on the Roadmap and Allocation table.
Allocation - Breaks down the engineer’s feature distribution by row with start and end data for each feature.