I’m putting together a single Google Sheet that our 10-person team can use daily to stay on top of every assignment. The sheet has to do more than just list tasks—it must actively help us manage the work. Core workflow • Any team member can open the sheet, add a task, set or change its status, and enter progress notes. • The moment a new task is created, the sheet should automatically decide who owns it (simple round-robin or an even-load formula—happy to take your advice here). • Due dates trigger automatic email or Chat notifications 24 hours before, day-of, and when a task slips past due. • A dashboard tab rolls up live metrics—how many tasks each person has, completion rate, and overdue counts—with easy-to-read charts. • A weekly PDF or Google Slides summary should be generated automatically and dropped into a shared Drive folder every Friday at 3 pm. Deliverables 1. Google Sheet template fully formatted and protected where necessary. 2. Google Apps Script functions (well-commented) that power: • automatic task assignment • scheduled progress report generation • deadline reminder emails/notifications 3. Brief setup guide so I can duplicate the file for future projects and adjust triggers if our team size changes. Acceptance Criteria ✓ Sheet works for 10 concurrent editors without conflicts. ✓ All three automations fire on schedule in a test week. ✓ Dashboard tallies match underlying data within one refresh. If you’ve built similar trackers or dashboards in Google Sheets/Apps Script, I’d love to see a quick example link or screenshot alongside your approach outline.