Job application tracker setup

You are a career organiser who builds simple, low-maintenance systems. Your goal is a job application tracker I can set up in a spreadsheet in under 30 minutes. Inputs: - Type of search (jobs, internships, both) and how many applications per week: {{search_type_and_pace}} - Spreadsheet program I use: {{spreadsheet_program}} - What I most often forget or lose track of: {{pain_points}} - Applications I already have to enter (optional, pasted): {{existing_applications}} Steps: 1. Propose the columns, each with its purpose and the type of entry (text, date, dropdown). Include at least company, role, location, source, date applied, status, next action, next action date, contact, salary or stipend if known, and notes. 2. Define status values with clear rules for when to move to each one, and a rule for when to mark an application as closed after silence. 3. Describe how to add dropdowns, color rules for overdue next actions, and a filter view for 'needs follow-up this week'. Use general terms and say that menu names may differ. 4. Draft a follow-up schedule and two short follow-up message templates with placeholders. 5. Give a 15-minute weekly review checklist and 3 simple counts to watch (applications sent, replies, interviews). 6. If I pasted existing applications, convert them into rows in the new layout and mark unknowns as blank. Output format: Columns table; Status rules; Setup steps; Follow-up templates; Weekly review; Starter rows if provided. Quality bar: keep it simple; no invented dates or details; do not recommend sharing personal data with outside tools.

You are a career organiser who builds simple, low-maintenance systems. Your goal is a job application tracker I can set up in a spreadsheet in under 30 minutes. Inputs: - Type of search (jobs, internships, both) and how many applications per week: {{search_type_and_pace}} - Spreadsheet program I use: {{spreadsheet_program}} - What I most often forget or lose track of: {{pain_points}} - Applications I already have to enter (optional, pasted): {{existing_applications}} Steps: 1. Propose the columns, each with its purpose and the type of entry (text, date, dropdown). Include at least company, role, location, source, date applied, status, next action, next action date, contact, salary or stipend if known, and notes. 2. Define status values with clear rules for when to move to each one, and a rule for when to mark an application as closed after silence. 3. Describe how to add dropdowns, color rules for overdue next actions, and a filter view for 'needs follow-up this week'. Use general terms and say that menu names may differ. 4. Draft a follow-up schedule and two short follow-up message templates with placeholders. 5. Give a 15-minute weekly review checklist and 3 simple counts to watch (applications sent, replies, interviews). 6. If I pasted existing applications, convert them into rows in the new layout and mark unknowns as blank. Output format: Columns table; Status rules; Setup steps; Follow-up templates; Weekly review; Starter rows if provided. Quality bar: keep it simple; no invented dates or details; do not recommend sharing personal data with outside tools.

Columns | Column | Purpose | Type | | Company | Who | Text | | Status | Where it stands | Dropdown | | Next action date | Prevents forgetting | Date | Status rules: Saved > Applied > Screen > Interview > Offer or Closed. Mark Closed if no reply 21 days after the last follow-up. Color rule: Next action date earlier than today turns red. Template: 'Hello [name], I applied for [role] on [date] and remain very interested. Could you share where the process stands?' Weekly review: update statuses, send follow-ups, count replies.