Step by step
- In a new sheet, type the headers: Task (A), Urgent (B), Important (C), Quadrant (D).
- Select B2:C, choose Insert > Checkbox.
- In D2, enter =IF(A2="","",IF(AND(B2,C2),"1 Do",IF(C2,"2 Schedule",IF(B2,"3 Delegate","4 Drop")))) and drag it down.
- On a second tab, make a 2×2 grid with the four quadrant labels.
- In each box, enter =FILTER(Tasks!A2:A,Tasks!D2:D="1 Do") (change the label per box).
- Use Format > Conditional formatting to color each quadrant.
Why checkboxes
A checkbox cell is TRUE or FALSE, so the formula can test it directly with AND(B2,C2), no Yes/No text needed. FILTER returns every row that matches, and it spills down automatically (Google Docs Editors Help).
Add-ons worth a column
| Column | Use |
|---|---|
| Deadline | Sort quadrant 1 with SORT(FILTER(...), 2, TRUE) |
| Done (checkbox) | Exclude done tasks: add a second FILTER condition, Tasks!E2:E=FALSE |
| Owner | Shows who takes quadrant 3 tasks |
Google Docs instead?
Docs has no formulas; insert a 2×2 table and type tasks in it. It works for a one-off, but Sheets updates itself.
Same idea in Excel: Eisenhower matrix in Excel. Or skip the sheet: the free online Eisenhower matrix.
Cronos, by Gambit Studio, is the same matrix on iPhone and iPad without a spreadsheet: add a task and put it in one of four quadrants by urgency and importance.