Integrate with Trello task board to store and summarize tasks in each project being implemented by the company to store project data for reporting purposes like delays
Client: Software Company, Hong Kong
- Trello (http://www.trello.com/) is a task management application. It gives visual representation of the task lists and who is working on them.
- We used Google Apps Script to access Trello API from Google Spreadsheet and read task lists for each project
- Added business logic to the tasks data in projects before storing them in the Spreadsheets – calculate number of story points associated with each task based on its complexity, delay in task from due date, group the tasks by project and user for easy reporting