Help

Help needed: Setup sprint workflow with subdeliverables that can be planned ahead

Solved
Jump to Solution
486 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Marksteady
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I am looking for help to setup a sprint workflow in my Airtable base to plan sprintdeliverables ahead in time.

I want to be able to plan subtasks (statuses within tasks) in future sprints. For example, I have a task, that has multiple subtasks such as Design, Development and Deploy. I want to be able to plan Design in sprint 22, Development in sprint 23 and Deploy in sprint 24. Ideally I would have a overview where I can see all sprints with all these subdeliverables in their respective sprints.

Who is able to help me?

Thanks!

Mark

1 Solution
7 Replies 7

Hmm, this seems fairly straightforward.  What issues did you encounter during setup? 

I can add a task to sprints, and multiple tasks to a sprint, ans also add a task to multiple sprints. The problem only is that every tasks have a fixed amount of subtasks (about 10) that I want to add to sprints. So 1 tasks exists in multiple sprints with different subtasks. For example: Task1-Design in sprint 22, Task1-Development in sprint 23 and Task1-Deploy in sprint 24. Hope this clarifies. Thanks!

Leslie_Burke
6 - Interface Innovator
6 - Interface Innovator

@Marksteady It sounds to me like your Tasks are your "WHAT you're going to accomplish", your subtasks are your "HOW you're going to complete your task" and your sprints are your "WHEN you're going to complete these things". The structure I would probably opt for is something like what I show below, where you have a table of sprints, a table of tasks and a table for subtasks. Subtasks are linked to the Sprints they occur in and AND the Task they are associated with. Then, I'd lookup (or more accurately, rollup, the names of the tasks from the subtasks that are in each Sprint on the Sprint table, thereby displaying all the of the tasks that are associated with a Sprint. Finally, if there is a standard set of sub-tasks that go with every task, I would probably have an automation auto-generate all of the subtasks for a task when I create it and then I would manually assign the subtasks to the sprints where they will be accomplished. Hope this is food for thought. 

image.jpeg

@Leslie_Burke that sounds like the right direction. Could you elaborate a bit more specifically what you mean with this? "Subtasks are linked to the Sprints they occur in and AND the Task they are associated with. Then, I'd lookup (or more accurately, rollup, the names of the tasks from the subtasks that are in each Sprint on the Sprint table, thereby displaying all the of the tasks that are associated with a Sprint."

Below an image of this situation. How would I get the unique Task + Subtask rollup? 

Thanks!

Marksteady_0-1710946122078.png

 

Khal01
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Mark, 

It looks like a few people have shared ways to accomplish your goal. If you continue to need support and would like someone to create the workflow, I would be more than happy to help. 

Khalid Mughal | Khal@wizential.com 

Colin1
4 - Data Explorer
4 - Data Explorer

Hi Mark,
If you are still on the lookout to hire someone, I would be glad to help you out as what you are wanting done is within my skillset
You can reach out to me on my email here
Colin