Step by step
- In row 1, type the headers: Task (A), Urgent (B), Important (C), Quadrant (D).
- Select B2:C100, go to Data > Data Validation > List, and enter Yes,No.
- In D2, enter =IF(AND(B2="Yes",C2="Yes"),"1 Do",IF(C2="Yes","2 Schedule",IF(B2="Yes","3 Delegate","4 Drop"))) and fill it down.
- On a second sheet, draw a 2×2 grid and label the quadrants.
- In each box, use FILTER to list that quadrant's tasks, e.g. =FILTER(Sheet1!A2:A100,Sheet1!D2:D100="1 Do","").
- Add conditional formatting to color column D by quadrant.
The quadrant formula, explained
| Urgent | Important | Result |
|---|---|---|
| Yes | Yes | 1 Do |
| No | Yes | 2 Schedule |
| Yes | No | 3 Delegate |
| No | No | 4 Drop |
If you don't have FILTER
FILTER needs Excel for Microsoft 365 or Excel 2021 and later. In older versions, sort the table by column D, or use an AutoFilter on the Quadrant column and copy the results into the grid. ExcelDemy shows a version built with helper formulas (ExcelDemy).
Tips
- Add a Deadline column and sort quadrant 1 by it.
- Add a Done checkbox and exclude done rows from FILTER with a second condition.
- Same formulas work in Google Sheets: Eisenhower matrix in Google Sheets.
Prefer not to build anything? The free online Eisenhower matrix runs in the browser.
Cronos, by Gambit Studio, is the phone version of this sheet: on iPhone or iPad you drop each task into one of four quadrants by urgency and importance, no formulas needed.