Skip to main content
Solved

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

M
Forum|alt.badge.img+4

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

Best answer by Leslie_Burke

@Marksteady Here's a quick loom that explains it more: https://www.loom.com/share/7a24d9b665ff4eebb4e8077f2bdbb5e5?sid=4c1b560e-dc3e-48e5-84c8-2c4301eda6db

View original
    Did this topic help you find an answer to your question?

    7 replies

    TheTimeSavingCo
    Forum|alt.badge.img+28

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

    Adam, Consultant @ thetimesaving.company
    M
    Forum|alt.badge.img+4
    • Marksteady
    • Author
    • Participating Frequently
    • 9 replies
    • March 20, 2024
    TheTimeSavingCo wrote:

    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!

    L
    Forum|alt.badge.img+16

    @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. 

    M
    Forum|alt.badge.img+4
    • Marksteady
    • Author
    • Participating Frequently
    • 9 replies
    • March 20, 2024
    Leslie_Burke wrote:

    @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. 


    @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!

     

    L
    Forum|alt.badge.img+16
    • Leslie_Burke
    • Inspiring
    • 51 replies
    • Answer
    • March 20, 2024

    @Marksteady Here's a quick loom that explains it more: https://www.loom.com/share/7a24d9b665ff4eebb4e8077f2bdbb5e5?sid=4c1b560e-dc3e-48e5-84c8-2c4301eda6db

    M
    1 person likes this
    • M
      Marksteady
    K
    Forum|alt.badge.img+5
    • Khal01
    • Known Participant
    • 18 replies
    • March 20, 2024

    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 

    C
    Forum|alt.badge.img+2
    • Colin1
    • Participating Frequently
    • 19 replies
    • March 22, 2024

    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

    Reply


    Most helpful members this week

    Terms & Conditions