Creating a Burn Down Chart

Kimberlee Adam · 05/20/19

Hello,

I'm a bit stuck on how, if it is even possible, to create a burn down chart. I'm importing raw data from Jira (we don't have the plug-in... yet) and we want to show a burn down of our defects backlog, along with optimistic and pessimistic and forecast. I'm able to do it in Excel so I've attached an image of something "similar" we'd like to do on a dashboard in Smartsheet.

I've already tried to create a separate spreadsheet with metrics and I tried creating a report but not sure how to even organize the data, if I can.

Burndown Chart (2).png

Alejandra · 05/22/19

Hi Kimberlee,

I came across this community post and thought you might find it helpful: https://community.smartsheet.com/discussion/burndown-chart

Andrée Starå · 05/30/19

Hi Kimberlee,

How did it go? Did you get it working with the sheets I shared?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike’ · 06/12/19

like this? I got it to work on a dashboard

ram.raviprolu · 06/24/19

How were you able to create this burndown? Did you use an additional sheet to store the metrics? Also, I was unable to use multiple data metrics in a single chart. Is there a trick to do that?

Tony Barthelemy · 06/25/19

Can you share your sheet? I would like to see how you set this up.

nlouie · 09/05/19

Hi Andrée,

Can you share the sheets you shared with Kimberlee, please? I'm also looking to see how burndown charts can be achieved within Smartsheet.

thanks!

-- nancy

Andrée Starå · 09/06/19

Hi Nancy,

I'd be happy to share.

Please send me an email at andree@workbold.com, and I'll share them with you.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

ib · 09/06/19

Andree, I'd be interested in this sheet as well.

Andrée Starå · 09/07/19

I'd be happy to share them with you as well.

Andrée Starå · 09/09/19

I've shared them with you now.

Hope you can use them!

nwexler · 11/20/19

Hi Andrée,

I am trying to get a burndown chart for Smartsheet, Would you be able to share the what you have done here in this post?

Thanks,

Nicole

Andrée Starå · 11/20/19

Hi Nicole,

If you email me I'd be happy to share two templates.

Ok?

Best,

Andrée

Alan Glaister · 02/11/20

Hi Andrée,

Would it be OK if I email you to receive the templates as well?

Thanks Alan

Andrée Starå · 02/11/20

Hi @Alan Glaister

I'd be happy to share them with you as well!

Please send me an email at andree@workbold.com, and I'll share them.

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

M38a1 · 02/25/20

Hey Andrée - I am going to email you as well for the burndown sheets. This'll be really helpful!

Creating a Burn Down Chart

Comments

Categories