Made a SCRUM Google Sheet with Automatic Kanban, Burn Down Chart and Velocity Metrics
The spreadsheet is based off a master list of User Stories.
The kanban, burndown chart and velocity are all automatically populated based on the status of a given User Story.
I attempted to make "drag and drop" (cut and paste) version of the kanban that allowed the user to move User Stories between categories by moving the User Story ID but this left an empty row in the cells that the data was being cut from. To ensure no blank rows/lots of manual white space removal I used the Query formula to populate the Kanban categories automatically. While this forfeits the handy drag and drop nature that comes with traditional Kanban webapps it adds the power of automatic charting and metrics that the free solutions demonstrated in this course lack.
Link to Google Sheet: https://docs.google.com/spreadsheets/d/1BfoDwGHw_UNewYVr817iGwGn7Ve68LRvI7fWJGHer-Q/copy