Advanced Google Sheets Operations Tracker

I need a seasoned Google Sheets pro to turn my scattered notes into a single, rock-solid tracker that streamlines our daily operations. The sheet must cover two main areas: 1) task assignments for everyone on the team and 2) performance metrics that show how well each task—and each person—progresses over time.

Here’s the level of depth I’m after: every task should carry a clear description, owner, start date, deadline, current status, and any dependencies that could delay delivery. I’d like automatic progress bars, color-coded alerts for overdue items, and a simple way to see how changes to one task ripple through the rest of the schedule. Think “mini-Gantt chart” right inside Sheets, with formulas (or Apps Script) doing the heavy lifting so no one has to update percentages manually.

On the performance side, I want a dashboard that pulls live data from the task sheet to show individual productivity, team throughput, and any bottlenecks. Simple slicers or dropdown filters must let me isolate a single employee, project phase, or date range in seconds.

Deliverables
• Master task sheet with advanced timelines, dependency logic, and progress calculations
• Automated performance dashboard drawing from the master sheet
• Built-in data-entry template for quick task creation (no layout breaks)
• Clear, commented formulas or Scripts plus a brief setup guide so my staff can use—-and tweak—-the file without calling you for every minor change

Acceptance criteria: all dependence links calculate correctly; status colors update instantly on date changes; dashboard visuals refresh with a single click; instructions tested by a non-technical teammate without confusion.

If this is squarely in your wheelhouse, let’s get rolling.