Sprint Charts

Angie Votek

Hi team,

Hope all is well for you!

Interested in understanding sprint charts/formulas to create that others are using. It would be for a 10 day sprint with 6 sprints for a PI. Perhaps, burndown, burn up, etc.

Thank you as I know all are busy!

Genevieve P.

Hi @Angie Votek

How is your data that you're looking to display currently stored in your sheets? For example, do you keep the historical data per-day in different rows, or is it a "live" sheet where one row is updated daily?

If you have one source sheet that is "live" but you want to chart historical data over time in order to see progress, I answered another post with a breakdown of how I would chart this data, here.

Point form process:

• Formulas in Sheet 1 calculate numbers each day
• A Copy Row workflow (in Sheet 1) runs once a week (or however often you need) to copy the data from Sheet 1 to Sheet 2
• A Record a Date workflow (in Sheet 2) runs when a new row is added to auto-populate that date.
• The Chart Widget is based off of Sheet 2's data, using the Date as the x-axis

Let me know if you have questions after taking a look at the other post!

Cheers,

Genevieve