You do not need to be a spreadsheet expert. These formulas work the same way in Excel and Google Sheets, and they all use the column letters from the table above.
Count applications by status
Type this in any empty cell outside column I, for example Q2:
=COUNTIF(I:I,"Applied")
It counts every row where the status is Applied. Swap the word to count other stages, such as "Interviewing" or "Offer". Do not put it inside column I itself, or the formula will try to count its own cell.
For a tidy dashboard, add a second tab called Summary, rename your main tab to Tracker, and use =COUNTIF(Tracker!I:I,"Applied") instead. To count every job you have logged, use =COUNTA(Tracker!A:A)-1, which counts filled cells in the Company column and subtracts the header.
Flag jobs that need a follow-up
Add a helper column O with the heading Flag. In cell O2, type:
=IF(AND(I2="Applied",TODAY()-H2>=7),"Follow up","")
Then copy it down the column. It shows "Follow up" when the status is still Applied and seven or more days have passed since the date in column H. Change the 7 to suit your own rhythm. Our guide on how to follow up on a job application has wording for the email itself.
Days since you applied
In a column P, a formula like =IF(H2="","",TODAY()-H2) shows how many days have passed, and stays blank until you add a date applied.
Overdue next steps
=IF(AND(L2<>"",L2<TODAY()),"Overdue","") marks any row where the next step date has passed. After an interview, the follow-up email after interview guide explains how long to wait.
If a formula shows an error
- Dates stored as text. If a date sits on the left of the cell, the program may be treating it as text. Re-type it, or set the column format to Date.
- Semicolons instead of commas. In some regional settings, spreadsheet formulas use semicolons between arguments. If a formula is rejected, try replacing the commas with semicolons.
- Typos in status values. A dropdown list solves this for good.