Setup

Google Spreadsheet Backlog

To turn a Google Spreadsheet into a backlog follow the following steps:

Install Script

1. Create a new spreadsheet or use an existing one.
2. Open the script editor under "Tools" -> "Script editor..."
3. If you have some scripts already, create a new blank script file under "File" -> "New" -> "Script file". If this is your first script for this document, you should have one file called "Code.gs" with one function in it that does not do anything. You can just remove all the code from it.
4. Cut and paste the contents of Scrum.gs into the blank script file.
5. Save the script file, and close the script editor.
6. Close and reopen the spreadsheet.

Create Project

1. If the script file has installed correctly, you should have new menu item at the top of your spreadsheet called "Scrum".
2. Click "Scrum" -> "Recofigure Project" to configure the current script as a Scrum project. Note that this can be run multiple times if you want to change any of the settings.
3. Fill in "Create Project" form:
   1. Themes: This is a list of themes (one per line) that your stories can have. This will add validation rules and colors to the story rows.
   2. Backlogs: These are the names of backlog sheets you want to use (one per line). If you're not sure why you would need more the one sheet just leave "Backlog" as is. Otherwise, you you'd like to have a separate sheet for future or past stories, you can add them here.
   3. Sprint Length: Choose your sprint length. This will be used to generate a burndown.
   4. Sprint Start Day: This is the day of the week you do sprint planning.
   5. Next ID: This is used to generate story IDs. You can probably leave it as is.
   6. Click "Go".
4. You should have one new sheet created for each one of the backlogs you defined, one called "Data" and one called "Config"