Google Sheet Task Tracker
Budget: $15 – $25 USD
I need our plain Google Sheet turned into a real task-tracking hub for my five-person team. Every user must be able to add, update, edit, or delete tasks either straight in the sheet or through a linked Google Form—whichever is easier for them at the moment.
Each row will hold a task, its owner (by email), status, and an expiry/due date. When that date is close or has passed, the owner should get an email and also see an in-sheet alert so nothing slips through the cracks. I’d like a clean dashboard tab that pulls the live data together: upcoming deadlines, overdue items, completion percentages, and quick filters by user.
Please keep everything inside Google Workspace: Google Sheets, Google Forms, and Apps Script for the automation. No paid add-ons.
Deliverables
• Dashboard tab that auto-refreshes and summarises tasks by owner and status
• Google Form mapped perfectly to the sheet’s columns
• Apps Script that runs daily (or on edit) to send email + in-sheet notifications when due dates are reached or missed
• Row-level editing control so each of the five users can only change their own tasks, while still seeing the whole tracker
• Brief hand-off guide and inline script comments so I can maintain it later
If you’ve built similar multi-user trackers, share a link or screenshot and let me know your timeframe.
Each row will hold a task, its owner (by email), status, and an expiry/due date. When that date is close or has passed, the owner should get an email and also see an in-sheet alert so nothing slips through the cracks. I’d like a clean dashboard tab that pulls the live data together: upcoming deadlines, overdue items, completion percentages, and quick filters by user.
Please keep everything inside Google Workspace: Google Sheets, Google Forms, and Apps Script for the automation. No paid add-ons.
Deliverables
• Dashboard tab that auto-refreshes and summarises tasks by owner and status
• Google Form mapped perfectly to the sheet’s columns
• Apps Script that runs daily (or on edit) to send email + in-sheet notifications when due dates are reached or missed
• Row-level editing control so each of the five users can only change their own tasks, while still seeing the whole tracker
• Brief hand-off guide and inline script comments so I can maintain it later
If you’ve built similar multi-user trackers, share a link or screenshot and let me know your timeframe.