Sprint Charts


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.
    Genevieve P. Employee Admin
    edited 09/22/21

    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!