sheetsmith

Templates › Personal goals

Job Application Tracker

Made for anyone job hunting.

Every application in one place: where it came from, what stage it has reached, and how your search is going overall. The summary carries a chart that redraws itself as you type.

Tabs
2
Columns
10
Fill themselves in
11

£7one payment, yours to keep

  • Opens in Excel, Google Sheets and Numbers
  • Delivered straight away
  • No macros, nothing to install
  • Change it free before you buy

Payment is handled by Stripe. Your card details go to them and never to us. Sales are final, which is why every tab, column and calculation is shown on this page first.

The workbook's summary and the table behind it
A row typed into the real file. Every figure that changes is the spreadsheet's own arithmetic.
The summary page, every figure calculated from the tables
The chart, drawn from the totals in the table beside it
What is inside: the tabs, the columns and what fills itself in
Where you type, and the shaded columns that work themselves out
The guide sheet that opens first and explains the file
Everything included in the download

Everything inside, before you pay

This is the whole design: every tab, every column and how each calculated one is worked out. White cells are yours to fill in; the shaded ones work themselves out and are locked so a formula cannot be overwritten by accident. There is room for 300 rows.

Applications

One row per job you apply for. Update the stage as things move along. Room for 300 rows.

ColumnTypeWorked out as
Companytext
Roletext
Salarycurrency
Where Foundchoice (list)
Date Applieddate
Stagechoice (list)
Reached Interviewbool
Days Since AppliednumberIF(ISBLANK([date_applied]), "", TODAY()-[date_applied])
Chase UptextIF(ISBLANK([date_applied]), "", IF(AND([stage]="Applied", TODAY()-[date_applied]>14), "Chase", ""))
Notestext

Summary

How your job search is going, updated as you fill in the Applications tab.

MeasureWorked out as
Total applicationsCOUNTA([Applications!company])
Still liveCOUNTIF([Applications!stage], "Applied")+COUNTIF([Applications!stage], "Screening")+COUNTIF([Applications!stage], "Interview")+COUNTIF([Applications!stage], "Offer")
Got to interviewCOUNTIF([Applications!interviewed], TRUE)
Response rateIFERROR((COUNTA([Applications!company])-COUNTIF([Applications!stage], "Applied")-COUNTIF([Applications!stage], "No Response"))/COUNTA([Applications!company]), 0)
Interview rateIFERROR(COUNTIF([Applications!interviewed], TRUE)/COUNTA([Applications!company]), 0)
Offers receivedCOUNTIF([Applications!stage], "Offer")
Applications needing a chaseCOUNTIF([Applications!chase_up], "Chase")
Applied this monthCOUNTIFS([Applications!date_applied], ">="&DATE(YEAR(TODAY()), MONTH(TODAY()), 1))
Average advertised salaryIFERROR(AVERAGE([Applications!salary]), 0)