
Closed
Posted
Paid on delivery
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 shared Gmail ID. When you reply include: • examples of past Google Sheets or Data Studio dashboards you have built, • your relevant experience with filter views and query/array formulas, and • a brief outline of how you would approach this project. I’m ready to start as soon as I see a clear plan that ticks every box above.
Project ID: 40672141
19 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average ₹1,648 INR for this job

As a seasoned full-stack developer, I've successfully created several Google Sheets and Data Studio dashboards that meet the highest standards of efficiency and visual appeal. I wholly understand the frustrations of clunky data management and analysis systems, especially when it comes to ensuring everyone has their personalized view. In previous projects, I've skillfully employed filter views and query/array formulas to achieve seamless independent filter functionality, even with multiple users on the same login. My solution will not disturb others' views while allowing each team member the freedom to search, sort, and analyze data as they need. Furthermore, I have extensive experience in developing dynamic, real-time dashboards that automatically update with new data. I will apply this expertise to your project ensuring your charts and metrics are always current and relevant without the need for any manual refreshes. My thorough understanding of Google Sheets coupled with proficiency in PHP-essential for business dashboards-will guarantee a clean, reliable final product that perfectly matches your needs.
₹1,050 INR in 7 days
7.1
7.1

Hello, We would be glad to assist you with this project. Protovo Solutions LLP is an experienced technology and business solutions agency serving global clients since 2016. We have successfully completed projects in custom software development, CRM and ERP customization, SaaS platforms, marketplaces, e-commerce, AI automation, digital marketing, and virtual assistance. Our team has hands-on expertise in Laravel, CodeIgniter, PHP, Node.js, React, Python, WordPress, Shopify, PrestaShop, OpenCart, PerfexCRM, RISE CRM, Odoo, APIs, automation, SEO, data management, and business support services. With more than 100 client reviews on Freelancer, we understand the importance of clear communication, reliable delivery, quality work, and ongoing support. We can review your complete requirements, recommend a practical approach, and execute the work through clear milestones. Relevant work samples and technical details can be shared during our discussion. Please connect with us through chat so we can discuss the requirement and take this forward. Kind regards, Protovo Solutions LLP
₹1,500 INR in 7 days
6.8
6.8

Hi there, I will re-engineer your master sheet with dedicated named **Filter Views** so each team member can sort, search, and analyse data independently without altering anyone else's screen on the shared Gmail login. Using dynamic `QUERY`, `ARRAYFORMULA`, and `FILTER` functions, I will create an auto-updating, mobile-friendly KPI dashboard tracking sales, pending tasks, and follow-ups by staff member. I will also provide a short Loom walkthrough demonstrating the entire workflow in action. Best regards, Nikhil Chandra Roy
₹1,050 INR in 1 day
6.4
6.4

With my top-notch expertise in handling large datasets and creating dynamic dashboards, I am a perfect fit for your project on revolutionizing your Google Sheets management. I have an impeccable track record of efficiently executing similar tasks and have created numerous user-friendly, real-time data analysis tools with tailor-made privileges that prioritize privacy, just as you need. To give you a glimpse of my capabilities, feel free to check out the data-heavy dashboards I've built using Google Sheets and Data Studio- they're all designed to simplify complex datasets and provide clear actionable insights. As for filter views and query/array formulas, I am well-versed in their implementation to ensure hassle-free information access while maintaining data integrity. Hiring me means getting fast, accurate work delivered within time frames. My commitment is to offer you a 100% satisfaction guarantee by providing samples (if necessary) and offering unlimited revisions until we create the perfect tool that fulfills all your objectives. Let's get started without delay and transform your Google Sheet into an efficient workspace for every team member!
₹7,050 INR in 1 day
6.3
6.3

Hello, I reviewed your project for Google Sheets Dashboard & Private Filters and I’d be glad to work on it. Your requirements are clear, and I have a good understanding of the result you’re looking for. I have experience with similar projects and can deliver the work with attention to detail, reliable communication, and a professional approach. You can also review my profile and portfolio: https://www.freelancer.com/get/muhammada742 I’d be happy to discuss the details with you and get started. Best Regards, Muhammad Abdul Samee
₹1,000 INR in 1 day
4.3
4.3

Thank you for considering my proposal. I have gone through the requirements in detail. I can restructure your Google Sheet so multiple team members can work independently while maintaining a protected master dataset and a live, easy-to-use dashboard. With 10+ years of experience in Excel, Google Sheets, data analysis and dashboard development, I am a Chartered Accountant (ICAI) and CPA. I have uploaded samples of similar Google Sheets, Excel dashboards and data-visualization projects completed by me earlier in my profile. My approach will be to separate the master data from user-facing analysis, implement protected ranges and independent Filter Views, and use QUERY, ARRAYFORMULA and other dynamic formulas where appropriate. I’ll design a single-page dashboard showing sales, pending work, follow-ups and completions by employee, with KPI cards, charts and filters that update automatically as the source data changes. I’ll also test the setup using the shared Gmail environment, verify that individual views do not interfere with colleagues, and provide a short Loom/Meet walkthrough covering maintenance and KPI customization. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Timely delivery ✅ 100% commitment to project completion I’m ready to build a scalable, collaborative and visually polished Google Sheets system that your team can use confidently every day.
₹1,000 INR in 2 days
3.6
3.6

As an experienced Senior PHP & Full-Stack Developer who has tackled various complex projects over the past decade, I can confidently say that I am well-equipped to streamline and innovate your Google Sheet processes and create a functional, visually-appealing dashboard. I have extensive proficiency in **restoring, improving, and specializing every note of your Google Sheets**. Regarding filters, I understand the crucial need for seamless and independent usage among users; I’ve skilled at implementing functionalities that allow multiple users to grapple the task without hinder user experience- no matter if they sign in with the same Gmail account, such as your case. Regarding my past experiences with data visualization and manipulation, I’ve worked on countless API driven web applications that process spools of **informative customer data using techniques like query/array formulas** to form real-time charts, graphs, and metrics - just what you need for your Google Sheets Dashboard. In broad terms, my approach will be analogous to a recipe-one that entails handpicking suitable tools (such as JavaScript and SQL), outlining each step, and producing a refined end product. Your trust in me will be rewarded with an efficient and scalable system where you don't have to rewrite formulas even when tweaking KPIs. Allow me to walk you through my pitch through a Loom or a Google Meet interaction.*
₹1,050 INR in 1 day
0.0
0.0

Hello, I hope you’re doing well. I reviewed your project requirements and I’m confident that I can help you build a high-quality, modern, and user-friendly solution according to your needs. Google-Sheets-Dashboard-Private-Filters I’m Ankur, a Full Stack Developer with 7+ years of experience in: • Custom Website Development • E-commerce Development • Mobile App Development • Flutter App Development • Android & iOS Applications • WordPress & PHP Development • UI/UX Design • Admin Panels & APIs I have successfully completed 500+ projects for startups, businesses, and individual clients worldwide. Why work with me? ✔ Clean and professional development ✔ Mobile-friendly and responsive design ✔ Fast communication and regular updates ✔ Scalable and secure solutions ✔ On-time delivery ✔ 3 months of free support after completion My goal is not just to complete the project, but to build a solution that helps your business grow. I would be happy to discuss your project in detail and start working immediately. Looking
₹2,050 INR in 18 days
0.0
0.0

I'll architect this using Google Sheets' native Filter Views paired with Apps Script to enforce independent user contexts, ensuring each team member sees only their filtered data while the master sheet remains protected. The dashboard will leverage QUERY and ARRAYFORMULA functions to pull real-time staff performance metrics (sales, pending work, follow-ups, completions) that auto-refresh whenever the source data changes. I'll design a clean, mobile-responsive dashboard with conditional formatting and sparklines for visual impact, plus built-in parameter controls so you can swap KPIs without touching formulas. I've delivered similar solutions combining Data Studio integration with Google Sheets backends, and I'm comfortable doing a live walkthrough using your shared Gmail to prove the filter isolation works perfectly across team members.
₹606 INR in 4 days
0.0
0.0

Hi —— I can upgrade the existing Google Sheet with named Filter Views that users open independently plus a clean one-page dashboard driven by the live main table. I will first preserve the source normalize ranges define the agreed KPIs build formulas and charts and test the filter-view links in separate browser sessions so one person’s filtering does not alter the base sheet. Because everyone shares one Gmail identity Google cannot provide distinct account-level ownership but Filter Views can still keep each active view non-disruptive. Delivery is 5 calendar days after access and KPI confirmation including brief usage notes and one focused revision. Please confirm the row count required KPIs and how many named filter views you want.
₹1,250 INR in 5 days
0.0
0.0

Hello, I am Vishwa Deo, a Government Servant with the Government of Rajasthan (GOR), formerly working as a Lower Division Clerk. I have strong typing skills, excellent attention to detail, and experience in handling official documents, data entry, MS Word, Excel, formatting, and administrative work. I am looking for freelance opportunities where I can utilize my typing and documentation skills to deliver accurate and timely work. I can handle data entry, PDF-to-Word conversion, document formatting, transcription, copy typing, and other administrative tasks professionally. I assure you of accuracy, confidentiality, timely delivery, and clear communication. I look forward to working with you. Thank you.
₹600 INR in 10 days
0.0
0.0

Filter Views gets you most of the way - each person opens their own view and sorts or filters without touching anyone else's screen. One thing to flag, because it changes the answer: Filter Views separate people by the account they signed in with. If everyone is on the same Gmail login, Google sees one user, so two people filtering at the same moment can still collide. If your team genuinely shares one login, I'd give each person their own view-tab rather than rely on Filter Views alone, and I'll show why in the walkthrough video. How many people use the sheet at once, and is the shared login a hard requirement or just how it's set up now? That decides which of the two approaches I build.
₹1,500 INR in 2 days
0.0
0.0

Panipat, India
Member since Aug 26, 2026
$250-750 USD
$30-250 USD
€8-30 EUR
₹1500-12500 INR
$250-750 USD
€12-18 EUR / hour
$30-250 USD
€30-250 EUR
$15-25 USD / hour
₹600-1500 INR
$250-750 USD
₹1500-12500 INR
$2500-5000 USD
$10-30 USD
₹1500-12500 INR
€750-1500 EUR
$250-750 USD
$2-8 AUD / hour
$10-30 AUD
$15-25 USD / hour