The Scenario
Sprint review is in two hours. You are the scrum master. You need a checklist completion report — how many items done vs. total — for each of the 45 cards on the sprint board, with percentages. The workbook is open and blank.
The bad version:
- Open the first card in Trello. Expand the checklist. Count the checked items. Count the total items. Note them.
- Open the second card. Count. Note.
- Forty-five cards. By card 20, the counting is taking longer than the planning meeting itself.
Velocity metrics are supposed to be derived from data automatically. Manually counting checkboxes the morning of a review is the antipattern the tool was supposed to eliminate.
The Easy Way: One Prompt in SheetXAI
SheetXAI fetches checklist data from every card and writes the completion stats into your workbook.
For every card on the Trello board 'Sprint 12', fetch its checklists and write the card name, total checklist items, and completed checklist items into this sheet. Add a column with the completion percentage.
What You Get
- One row per card with a checklist.
- Columns: card name (A), total items (B), completed items (C), completion percentage (D).
- Percentage calculated as completed / total.
- Cards with zero checklist items either noted separately or omitted, per your preference.
What If the Data Is Not Quite Ready
You want separate rows per checklist when a card has multiple checklists
Get all checklists from every card in the Trello list 'In Progress'. For each checklist, write the card name, checklist name, number of done items, and total items into separate rows in this workbook.
You only want cards below a completion threshold
For every card on the Trello board 'Sprint 12', fetch its checklists. Write card name, total items, completed items, and percentage into this workbook. Only include cards where completion is below 50%.
You need the individual checklist item names, not just counts
For every card on the Trello board 'Sprint 12', fetch all checklists. For each checklist item, write the card name, checklist name, item name, and whether it is complete (yes/no) as separate rows in this workbook.
Pull the data, flag incomplete cards, and add a board-level summary
For every card on the Trello board 'Sprint 12', fetch its checklists. Write card name, total items, completed items, and percentage into columns A-D. Flag any card below 80% completion as 'needs attention' in column E. Add a board-level summary row at the bottom: total items, total completed, overall percentage.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook before your next sprint review, then ask it to pull checklist completion stats from your Trello board. Also useful: Export a Trello board into an Excel workbook or the Trello integration overview.