Phoenix - Your AI AssistantGoogle Sheet
- Posted:
- Proposals: 14
- Remote
- #4482098
- Open for Proposals
Islamabad 
Description
Experience Level: Entry
I have a list of unpaid client services (large projects + monthly payments) and need a single, clean Google Sheet:
Columns: Client, Service, Month (split multiple months), Total, Paid, Remaining (Total–Paid), Status (Unpaid/Partial/Paid, auto-calculated)
Sections: Projects and Monthly Payments
Automation: Remaining and Status formulas
Totals: Overall Total, Total Paid, Total Remaining (optionally per client)
Conditional Formatting: Red=Unpaid, Yellow=Partial, Green=Paid
Usability: Google Sheet Table with filters for Client, Month, Status
Budget: $20
Columns: Client, Service, Month (split multiple months), Total, Paid, Remaining (Total–Paid), Status (Unpaid/Partial/Paid, auto-calculated)
Sections: Projects and Monthly Payments
Automation: Remaining and Status formulas
Totals: Overall Total, Total Paid, Total Remaining (optionally per client)
Conditional Formatting: Red=Unpaid, Yellow=Partial, Green=Paid
Usability: Google Sheet Table with filters for Client, Month, Status
Budget: $20
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Xander
Should the monthly entries auto-expand when new data is added?
Thanks.
Do you prefer a simple layout or something more visual (dashboard-style)?
Thanks. -
Hey Xander, could you please share the source data in a list or spreadsheet so we can start working?