Creating a Burn Down Chart

Kimberlee Adam

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.

Alejandra

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å

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’

like this? I got it to work on a dashboard 

ram.raviprolu

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

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

nlouie

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å

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

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

Andrée Starå

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

Andrée Starå

I've shared them with you now.

Hope you can use them!

nwexler

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å

Hi Nicole,

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

Ok?

Best,

Andrée

Alan Glaister

Hi Andrée,

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

Thanks Alan

Andrée Starå

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

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