Hunt — job application tracker

Pro workbook: Applications, Pipeline, Follow-ups, Setup, Formulas. Sample data, real formulas.

Job applications
One row per application. Days waiting and who needs a nudge are calculated; the rest is yours.
As of14 SepApplications9
Nudge after (days)7Active7
Interviews1
Offers1
CompanyRoleSourceAppliedStageLast contactNext stepNext dateSalaryDaysSince contactActiondo #nudge #Response rate56%
Harbor LtdFrontend engineerJob board18 AugInterview10 SepTechnical interview16 Sep68,000274WaitNeed action3
Grove StudioProduct designerReferral25 AugScreening2 SepWait for recruiter62,0002012Nudge1
LarkfieldWeb developerCompany site28 AugApplied55,0001717Nudge2
Mercer & CoUX engineerLinkedIn1 SepRejected8 Sep70,000136Closed
AuroraFrontend engineerRecruiter3 SepScreening12 SepSend portfolio15 Sep72,000112Wait
Bistro GroupMarketing site leadJob board5 SepApplied58,00099Nudge3
FathomDesign engineerReferral12 AugOffer11 SepDecide by Friday18 Sep75,000333Wait
MarginaliaFront-end developerJob board20 AugWithdrawn30 Aug50,0002515Closed
Slate SystemsSoftware engineerLinkedIn9 SepApplied66,00055Wait
Pipeline
How many applications sit at each stage, how far they get, and how long they've been waiting.
StageCountShareAvg daysReached
Applied333%109
Screening222%164
Interview111%272
Offer111%331
Rejected111%131
Withdrawn111%251
All9
ConversionRate
Applied → Screening44%
Screening → Interview50%
Interview → Offer50%
Applied → Offer11%
SourceApplicationsInterviews+Rate
Job board3133%
Company site1
Referral2150%
Recruiter1
LinkedIn2
'Reached' counts applications that got at least this far: everything at Interview or Offer once passed Screening. Conversion rates divide those.
Avg days = days since applied, averaged over applications currently at that stage.
Follow-ups
Everything marked Do it or Nudge on Applications, listed. Ten rows each.
Do itRoleNext stepDaysNudgeRoleNext stepDays
Grove StudioProduct designerWait for recruiter12
LarkfieldWeb developer017
Bistro GroupMarketing site lead09
Setup
The as-of date, the nudge period, the stages and the sources.
As of2026-09-14Type =TODAY() to keep it live
Nudge after (days)7
StagesSources
AppliedJob board
ScreeningCompany site
InterviewReferral
OfferRecruiter
RejectedLinkedIn
Withdrawn
The Pipeline sheet's conversion rates are written for these six stage names in this order — rename the sources freely, keep the stages.
How the formulas work
Every formula in this workbook, in plain words. Nothing is hidden and nothing needs a macro. Formulas are shown without the leading = sign.
WhereFormulaWhat it does
Applications · Days$B$3-D8As-of minus the application date.
Applications · Since contact$B$3-IF(F8="",D8,F8)From the last contact, or from the application if there was none.
Applications · ActionIF(OR(E8="Rejected",E8="Withdrawn"),"Closed",IF(AND(H8<>"",H8<=$B$3),"Do it",IF(K8>=$B$4,"Nudge","Wait")))Closed stages first; then a next date that has arrived; then silence longer than the nudge period.
Applications · Response rate(all-Applied-Withdrawn)/allAnything that moved past Applied, including rejections, over everything sent.
Applications · do #IF($L8="Do it",COUNTIF($L$8:$L8,"Do it"),0)Numbers the Do-it rows 1, 2, 3 in order; Follow-ups looks them up by number — no FILTER.
Pipeline · Avg daysAVERAGEIF(Applications!$E$8:$E$107,A5,Applications!$J$8:$J$107)Days since applied, averaged over the applications currently at this stage.
Pipeline · ReachedB6+B7+B8Applications that got at least to Screening: those at Screening, Interview or Offer now.
Pipeline · ConversionE6/E5Reached the next stage over reached this one.
Follow-ups · row kIFERROR(INDEX(Applications!$A$8:$A$107,MATCH(1,Applications!$M$8:$M$107,0)),"")The company whose do-number is 1, then 2 …