Project: Kids 4 Truth Google Sheet – Permissions, Protection & Audit Tweaks We already have an existing Google Sheets workbook built for Kids 4 Truth points tracking. The layout, formulas, colors, and structure should remain unchanged. The task is to refine permissions, protections, and change tracking only. Platform • Google Sheets (existing file) • Do NOT rebuild from scratch • Preserve current layout, colors, formulas, and sheet names ⸻ User Roles & Access Levels 1. Administrators (exactly 2 users) Admins must be able to: • Edit all sheets, cells, formulas, and protections • Add or remove students • Adjust point values and rules • Add new weekly date columns • View full version history • Restore prior versions Admins have unrestricted access. ⸻ 2. Group Leaders (exactly 4 users) Each group leader should: • Access only their assigned color group sheet (Yellow, Green, Red, or Blue) • Edit only weekly point input cells for their students • NOT be able to: • Edit formulas or totals • Edit headers or date rows • View or edit other group tabs • Remove protections Use Protected Sheets and Protected Ranges to enforce this. ⸻ 3. View-Only Users (Unlimited) Some users should: • Be able to view the entire workbook • NOT be able to edit any cells • NOT be able to remove protections • NOT see hidden admin or calculation sheets (if applicable) ⸻ Protection Requirements (Critical) • Lock all formula cells (weekly totals, grand totals, rollups) • Lock headers and date rows • Restrict editing to numeric input cells only for group leaders • Admins must be able to override all protections ⸻ Change Tracking & Accountability Version History (Required) • Google Sheets version history must remain enabled • Admins must be able to: • See who edited what • See date and time of edits • Restore prior versions Automatic Date / Time Stamps (Required) • When weekly point values are edited: • A protected column auto-updates with date (MM/DD/YYYY) and time • Timestamp cells must not be editable by group leaders • Timestamp logic must be row-specific and reliable Google Apps Script is acceptable only for timestamps. ⸻ Scope Clarifications • Do NOT redesign the sheet • Do NOT change color coding • Do NOT restructure student rows • Focus only on permissions, protections, and audit trail ⸻ Deliverables • Updated Google Sheet with: • 2 Admins, 4 Group Leaders, and View-Only users correctly configured • Protected formulas and headers • Working timestamps • Brief handoff notes explaining: • How to add users • How to assign roles • How to restore prior versions ⸻ Success Criteria • Group leaders can only edit their own group’s weekly inputs • View-only users cannot edit anything • Admins can change anything at any time • No formulas or totals can be broken • All changes are traceable and reversible