Google Sheets Dashboard & Private Filters
Employer not named by the sourceRemote
Frontier is not the employer and does not collect applications.
About this role
PHP, Graphic Design, Excel, HTML, Data Visualization, Data Analysis, Google Sheets, Google Data Studio · I want to upgrade our current Google Sheet so every team member can sort, search, or analyse data without disturbing anyone else’s view, even though we all sign in with the same Gmail account. Alongside that, I need a single-page dashboard that pulls live numbers from the main sheet and shows them in a clean, visually appealing layout.
Core priorities - Independent Filter Views: each user must be able to turn filters on or off without altering what colleagues see. Please be ready to demonstrate this with the shared Gmail login. - Dynamic Dashboard: charts and metrics should refresh automatically as new rows are added or edited. - Staff-wise tracking: the dashboard needs to break down sales, pending work, follow-ups and completions by employee.
Dashboard must combine strong visual design, real-time updates, and fully customisable widgets so I can tweak KPIs later without rewriting formulas.
Deliverables 1. Main sheet re-engineered with protected master data and personalised filter views. 2. Linked dashboard sheet that updates instantly, requires no manual refresh, and works on desktop and mobile. 3. Short Loom or Meet walk-through showing the setup in action using the