Aug 20, 2020 03:10 PM
I am trying to build out an automated(ish) roadmap and resource planning base that will schedule features based on sprint start/end dates and resource availability.
This google sheet is the auto-scheduling functionality that I am trying to mimic. The sheet takes in to account available headcount and automatically schedules dates based on availability. I’d like to accomplish something similar in airtable , but using the sprint table start and end date data to drive roadmap dates and assign features to the team based on availability. Roadmap Planning Example - Google Sheets T
The problem that I have are as follows.
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.
Aug 29, 2020 11:47 AM
Crickets…help me please
Sep 12, 2020 08:40 AM
Hey Joe! I don’t know the answer to yours but I’ve been searching sprints and maybe you might know the answer to this – how do I change the current sprint? Is it automatic based on calendar week? or can I customize the start and end of a sprint such that my “current sprint” view changes automatically.
Is there a way to take any card that hasn’t been marked as “done” in one sprint, to carry over to the next when the current sprint is over?
Is there a way to change the cards marked as “done” into closed or archived status once the sprint is over?
Sorry not able to assist you, but thankful if you can provide any guidance.