Google Sheets Expert (Apps Script) — Fix Defined List of Formula & Import Issues

The work includes: • Fixing formula ranges that are capped too low (missing rows of data) • Correcting a calls-per-hour formula (wrong denominator) • Cleaning up data validation dropdowns • Fixing a staff name mapping table (mismatched values breaking lookups) • Repairing broken IMPORTRANGE links (some cache #REF!) • Minor Apps Script work (an onEdit auto-timestamp) What makes this straightforward: • Every fix is documented with the exact location and the change needed • Work is “fix in place” — no rebuilding, no restructuring • Scope is bounded and clear — you’ll know exactly what “done” looks like What I need from you: • Strong Google Sheets skills: IMPORTRANGE, QUERY, SUMIFS/COUNTIFS, data validation • Apps Script experience (onEdit triggers) • Careful, methodical worker who preserves existing structure and doesn’t break downstream formulas • Reliable communication — this is important to me; my last developer went quiet mid-project • Ability to document what you changed (before/after) as you go Process: I’ll share the fix list and view access. You work through it in priority order, confirming the first (urgent) item before continuing. When complete, I verify each fix against the audit before sign-off. To apply: Briefly tell me your experience with multi-sheet Google Sheets systems and Apps Script. Mention “ROSTER” at the top of your reply so I know you read this — I’ll ignore generic copy-paste applications.