Building A Sheet That is Agile Velocity Focused

Chris Power

It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary.

 

https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing

 

So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin)  It also allows him to change the velocity to change how long in the chart it takes.  Since each row is independent when you rearrange the rows it still works (for example if the priorities change)

 

The formulas move over to smartsheets fine (although I wish there were some automated smarts to do this for me instead of me manually putting them in) The real obstacles are 

1. The formulas for some reason don't stay.  I use them and the result shows but I can't edit them afterward.

2. If I reprioritize it breaks the formulas

3. It doesn't allow me to overlap tasks in the sprint

 

I'll recreate the smartsheet what I can and share the link once its done for some more help if you think it'll help

 

 

 

 

Chris Power

I think I've got most of it working here.  Besides being able to reprioritize the rows easily

 

https://app.smartsheet.com/b/publish?EQBCT=a3d586c6d04b4793848e7fa1bbd64497

 

Chris Power

So I guess is there a way to make my start date field just look up at the end date field above it dynamically?

 

What I'm getting at if I reprioritize the list the formula holds what line it is supposed to be pulling the end date field data from.  Which after it's reprioritized at it's naturally wrong.

 

 

Brett Evans

Cloogy work around.  Since the formula set is limited, this would be my approach.

https://drive.google.com/file/d/0Byg5wjaEvFYUc3FueE9qb0YxTTA/view?usp=sharing

 

dserodio

Chris, I'm currently evaluating Smartsheet for managing agile software development and came across this post. Are you using Smartsheet to manage the Epics and User Stories themselves, or something else? Your "Epic Ticket" IDs remind me of Jira...

 

Thanks!