I want a lightweight applicant-tracking system that lives entirely in Google Sheets for my recruitment agency. Candidates will enter through a Google Form; their details must feed straight into a master data sheet that can comfortably handle multiple clients, their individual vacancies, and every application tied to each job. A clean dashboard inside the workbook should update in real time, showing: • Total number of applications received • Number of jobs per client • Live breakdown of application statuses (e.g., New, Short-listed, Interviewing, Hired, Rejected) Please structure the data so I can slice or filter by client, by job, or by status without breaking formulas. Standard data security is enough, so protected ranges and sensible sharing permissions will do—no need for enterprise encryption layers. I do not need email or in-app alerts; I’ll review the sheet manually. Deliverables • Google Form linked to the sheet • Master data tab with all captured fields, properly normalised • Dashboard tab with charts/metrics described above, driven by formulas or pivot tables • Brief hand-off note explaining sheet logic and how to add new clients or roles If Apps Script is the smartest way to keep everything tidy or automate look-ups, feel free to use it, but keep the solution contained within Google Workspace. I’m aiming for clarity, speed, and ease of maintenance rather than complex extras.