Guide · Cronos

Eisenhower matrix in Google Sheets: free, with checkboxes

Quick answer

To create an Eisenhower matrix in Google Sheets, list tasks with two checkbox columns, Urgent and Important, add an IF formula that names the quadrant, and fill a 2×2 grid on a second tab with the FILTER function. Everything updates as soon as you tick a box, and it is free.

Updated 2 min readGambit Studio

Use without installing →Free in your browser, no sign-up

Step by step

  1. In a new sheet, type the headers: Task (A), Urgent (B), Important (C), Quadrant (D).
  2. Select B2:C, choose Insert > Checkbox.
  3. 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.
  4. On a second tab, make a 2×2 grid with the four quadrant labels.
  5. In each box, enter =FILTER(Tasks!A2:A,Tasks!D2:D="1 Do") (change the label per box).
  6. 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

ColumnUse
DeadlineSort quadrant 1 with SORT(FILTER(...), 2, TRUE)
Done (checkbox)Exclude done tasks: add a second FILTER condition, Tasks!E2:E=FALSE
OwnerShows 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.

Sources

  1. Google Docs Editors Help: FILTER function
  2. The American Presidency Project: Eisenhower's address in Evanston, Illinois, August 19, 1954

Free in your browser

Use it free now, nothing to install

The core of the app works right in your phone or computer browser.

Frequently asked questions

What people ask most about this, answered with the source.

Is there an Eisenhower matrix template for Google Sheets?
There are free ones online, but building your own takes about 10 minutes with checkboxes, IF and FILTER.
What formula sorts tasks into quadrants in Google Sheets?
=IF(AND(B2,C2),"1 Do",IF(C2,"2 Schedule",IF(B2,"3 Delegate","4 Drop"))) with checkboxes in B and C.
Can I use an Eisenhower matrix in Google Docs?
Yes, as a static 2×2 table. For automatic sorting, use Sheets.
How do I hide done tasks?
Add a Done checkbox column and a second FILTER condition that keeps only unchecked rows.
CronosPriority control Eisenhower
Use without installingGet