A job application spreadsheet works when it does the remembering for you, which means it needs a status dropdown, two or three date formulas, and one column that tells you what to do today.
It’s easy to start a sheet during a burst of energy, type in the first ten applications, and watch it go stale. In my view the problem isn’t laziness. The sheet is a list, and a list can’t tell you that Thursday is the day to follow up on the Brightwell application. You have to remember to look, and remembering to look is the very thing you were trying to stop doing.
So this guide is a build guide. You’ll set up eight columns, add a dropdown, write three short formulas, add color, and test the whole thing with a fake row before you trust it. It works in Google Sheets and in Excel, though menu names differ a little. A chatbot can help you write the formulas if you give it your column layout and stop it from guessing. The company names, dates, and results in the examples are invented. This is general information, not career advice.
Contents
Why a Plain List Stops Working
A list records what happened. A working tracker also answers a question every morning: what needs my attention today?
That second job needs two things a plain list doesn’t have. One is a consistent status, so you can tell an application you just sent from one that has an interview attached. The other is a date that does arithmetic, so the sheet notices when an application has been quiet for a week without you noticing.
None of this needs a special app. A sheet with a handful of formulas does it.
The Eight Columns
Keep it to eight. Every extra column is one more thing you’ll skip filling in.
- A: Company. A short, consistent name.
- B: Role. The title as posted.
- C: Applied. The date you submitted, entered as a real date.
- D: Status. Picked from a dropdown.
- E: Next action. A formula, not typed.
- F: Flag. A formula that says “Follow up” or “Wait.”
- G: Days waiting. A formula.
- H: Link. The posting address.
You type in A, B, C, D, and H. The sheet fills in E, F, and G.
Seven Steps to Build the Sheet
Step One: Type Dates as Real Dates
This sounds trivial, and it’s where most broken sheets go wrong. A date has to be a real date for arithmetic to work. If you type 3/3/2026 and it lines up on the right side of the cell, it’s a real date. If it hugs the left side, the sheet is treating it as text and the formulas below will give you errors or blanks.
If your dates came out as text, retype one and watch how it aligns. Choose one date format and keep it. Don’t mix “3/3” in one row with “March 3” in another.
Step Two: Add the Status Dropdown
A dropdown keeps your wording identical every time, and formulas depend on identical wording. “Applied” and “applied ” with a trailing space are two different things to a formula.
In Google Sheets, select the Status column cells, open the Data menu, choose Data validation, and add a rule. In Excel, look for Data Validation under the Data tab and choose a list. Type your options separated by commas.
A short list is enough to start:
| Status |
|---|
| Applied |
| Talking |
| Closed |
You can split “Talking” into more steps later. Our guide to job search pipeline stages explains how to decide what each one means. For now, three is plenty.
Step Three: The Next Action Formula
In E2, enter this:
=IF(D2="Applied",C2+7,"")
Read it out loud: if the status is Applied, take the applied date and add seven days. Otherwise, leave the cell blank.
The 7 is your choice, not a rule. There’s no official right number of days. Pick a gap you’re comfortable with, and change the number if you want a different rhythm. Our guide on how to follow up after applying goes through the wording and the timing choices.
An invented check: if C2 says March 3, E2 should show March 10. If it shows a strange number like 46091, the cell is formatted as a number. Change the format to a date and it will display correctly.
Copy the formula down the column so every row has it. In most sheets you can drag the corner of the cell, or double-click it.
Step Four: The Flag Column
In F2, enter:
=IF(E2="","",IF(TODAY()>=E2,"Follow up","Wait"))
This says: if there’s no next action date, show nothing. Otherwise, if today has reached that date, say “Follow up.” If not, say “Wait.”
TODAY() updates itself whenever you open the sheet. That’s what makes it work like an alarm. You don’t need to do anything.
Step Five: Days Waiting
In G2:
=IF(D2="Applied",TODAY()-C2,"")
If the status is Applied, subtract the applied date from today. The result is the number of days you’ve been waiting. An invented example: applied March 3, today is March 12, so G2 shows 9. This number is useful for spotting the ones that have gone quiet for a long time, and it feeds directly into the archive rule in the stages guide.
Some regional settings use a semicolon instead of a comma inside formulas. If a formula gives an error and looks right, try swapping the commas for semicolons.
Step Six: Add Color So You See It Instantly
You want the Follow up rows to jump out. Use conditional formatting. Select the rows you want to color, open the conditional formatting menu, and choose a custom formula rule. Enter:
=$F2="Follow up"
Pick a light yellow fill. Now any row whose flag says Follow up turns yellow on its own. You can add a second rule for Closed rows, such as gray text, so finished applications fade into the background.
Step Seven: Test With a Fake Row
Before you trust anything, enter a row you know the answer to. An invented test:
| Field | Value |
|---|---|
| Applied | 8 days ago |
| Status | Applied |
| Expected flag | Follow up |
If the flag says Follow up and the row turns yellow, your formulas work. Then change the status to Closed. The next action date and the flag should go blank. If they don’t, check that your dropdown text matches the formula exactly.
Delete the fake row afterward. Skipping this test is the most common reason a person trusts a sheet that has been quietly broken for weeks.
Let a Chatbot Write the Formulas
If your layout differs from mine, a chatbot can adapt the formulas. The risk is that it guesses column letters or assumes a tool you aren’t using. This prompt prevents that:
I'm building a job application spreadsheet in [Google Sheets / Excel]. My columns are:
A: Company, B: Role, C: Applied (date), D: Status (dropdown: Applied, Talking, Closed), E: Next action, F: Flag, G: Days waiting, H: Link.
Please write:
1. A formula for E2 that adds [7] days to C2 only when D2 is "Applied", and is blank otherwise.
2. A formula for F2 that shows "Follow up" when today has reached E2, "Wait" when it hasn't, and blank when E2 is blank.
3. A formula for G2 that shows days since C2 only when D2 is "Applied".
4. A conditional formatting rule that colors a row when F is "Follow up".
For each formula, write one sentence explaining it, then give a test row with the expected result.
Rules:
- Use only the columns I listed.
- If any menu name or function differs between my tool and others, say so instead of guessing.
- Do not add columns or features I didn't ask for.
- If anything is unclear, ask before writing the formula.
The prompt above is my own wording, not an official or published template.
Always run the test row it gives you. If the result doesn’t match the expected answer, the formula is wrong, even if it looks plausible.
Keeping the Sheet Useful After Week One
Sort by the Date, Not by When You Applied
Once the formulas work, the most useful habit is a single sort. Sort by the Next action column, earliest first. The applications that need you are at the top, and the finished ones sink to the bottom. Some sheets also let you set up a filter so you can hide Closed rows altogether.
If you keep one view only, keep this one. It turns the sheet from a record into a to-do list.
When to Add a Column
Resist the urge for a while. After a few weeks, if you notice a real gap, add one. A “Response date” column can help if you want to compare later. A “Resume version” column helps when you try different versions, which our guide on the resume A/B test explains. Both are worth adding only when you’ll actually use them.
If you want to measure effort and replies, the job application response rate guide shows how to add a minutes column and calculate from it.
If You Are Collecting Unemployment, This Sheet Can Double as Your Log
The U.S. Department of Labor, Training and Employment Notice 17-19 says federal law requires states to have a work-search requirement for unemployment claimants, and many states require you to keep a log of your search activity. Your Company, Role, Applied and Link columns already hold most of what a log asks for, so add the contact method if your state asks for it. Requirements differ by state, so use the log format your state’s unemployment agency specifies when it gives one.
Why a Quiet Application Is Not Always a No
The Yale SOM Career Development Office says delays are often unrelated to the candidate. That is why the sheet marks a row “Follow up” instead of “Rejected” when the waiting days pass.
Where These Sheets Usually Break
- Dates typed as text. Check the alignment.
- Dropdown wording that doesn’t match the formula. Copy it exactly.
- Formulas typed only in the first row. Fill them down.
- Skipping the fake-row test. Always run one.
- Too many columns. Eight is enough to start.
- Never opening it. Put a weekly time in your calendar.
Questions About Job Application Spreadsheet
What should a job application spreadsheet include? Company, role, applied date, status, a next action date, a flag, days waiting, and a link. The dates and flags can be formulas.
Does this work in both Google Sheets and Excel? The formulas are the same in both. Menu names for dropdowns and conditional formatting differ slightly.
How many days should I wait before following up? There’s no official number. Choose a gap you’re comfortable with and change the 7 in the formula to match.
Can AI write the formulas? Yes, if you give it your exact columns and ask for a test row. Run the test yourself before you trust it.
Do I need a paid tool instead? Not to get started. A simple sheet is enough to find out what you actually need.
Build It Tonight, Test It Once
Set up the eight columns, add the dropdown and three formulas, and run one fake row. A job application spreadsheet that flags its own follow-ups is worth far more than a longer list you have to remember to read.
This article offers general information, not career advice. Menu names and features can differ between spreadsheet tools and versions. The example companies, dates, and results are fictional.
Sources:
Leave a Reply