Simple 2-Sheet Google Spread Application Development
Budget: ₹600 – ₹1,500 INR
Job Title: Google Sheets Expert Needed for a Simple 2-Sheet Management Application
Job Description:
Hi there,
I am looking for an experienced Google Sheets expert to build a very simple, fully automated 2-sheet application for our Mutual Aid Society. There is no need for external databases, Firebase, or complex app development—everything will strictly run inside Google Sheets using advanced formulas.
Project Overview (Strict 2-Sheet Architecture):
Sheet 1 (Transaction Log): A simple data entry sheet where our staff will record daily transactions (Receipts, Payments, Loans, etc.).
Sheet 2 (Automated Dashboard): A fully formula-driven dashboard that auto-calculates Society Totals, Member-wise balances, and auto-generates a Defaulters list.
Technical Skills Required:
Expertise in advanced Google Sheets formulas (SUMIFS, VLOOKUP, FILTER/QUERY, ARRAYFORMULA).
Conditional Formatting (to highlight defaulters with Red alerts).
Data Validation & Sheet Protection (to strictly lock formula cells and restrict admin access).
Basic Google Apps Script (to write a simple script that locks previous months' data to prevent backdated entries).
I have a highly detailed requirements document ready. It provides the exact column names, the exact SUMIFS logic needed, and the strict UI/UX rules you need to follow. Since the logic is already mapped out, this will be a very straightforward and fast job for someone who knows Google Sheets well.
Please apply if you can deliver a clean, highly secure, and bug-free sheet. Mention "2-Sheet Expert" at the start of your proposal so I know you have read this.
Looking forward to your bids!
Job Description:
Hi there,
I am looking for an experienced Google Sheets expert to build a very simple, fully automated 2-sheet application for our Mutual Aid Society. There is no need for external databases, Firebase, or complex app development—everything will strictly run inside Google Sheets using advanced formulas.
Project Overview (Strict 2-Sheet Architecture):
Sheet 1 (Transaction Log): A simple data entry sheet where our staff will record daily transactions (Receipts, Payments, Loans, etc.).
Sheet 2 (Automated Dashboard): A fully formula-driven dashboard that auto-calculates Society Totals, Member-wise balances, and auto-generates a Defaulters list.
Technical Skills Required:
Expertise in advanced Google Sheets formulas (SUMIFS, VLOOKUP, FILTER/QUERY, ARRAYFORMULA).
Conditional Formatting (to highlight defaulters with Red alerts).
Data Validation & Sheet Protection (to strictly lock formula cells and restrict admin access).
Basic Google Apps Script (to write a simple script that locks previous months' data to prevent backdated entries).
I have a highly detailed requirements document ready. It provides the exact column names, the exact SUMIFS logic needed, and the strict UI/UX rules you need to follow. Since the logic is already mapped out, this will be a very straightforward and fast job for someone who knows Google Sheets well.
Please apply if you can deliver a clean, highly secure, and bug-free sheet. Mention "2-Sheet Expert" at the start of your proposal so I know you have read this.
Looking forward to your bids!