I will build a google sheets job tracker and simple sops for your small business
About this Gig
Still tracking jobs on paper, sticky notes or in your head? I'll build you a simple Google Sheets system your team will actually use. I'm studying operations management and work in automotive manufacturing, so it's built around how work really flows.
Included
- Job/order tracker with dropdown statuses, auto "days open" and overdue flags
- Dashboard: open jobs, quotes waiting, ready to collect, unpaid invoices
- Written SOPs (step-by-step procedures) for your key process
- Works in Google Sheets and Excel
Platform:
Excel
•
Google Sheets
Development technology:
Google Apps Script
•
Excel
•
VLOOKUP
Expertise:
Formatting
•
Formulas
•
Functions
•
Dashboard
•
Data validation
FAQ
Do I need paid software?
No. A free Google account is enough.
Can you automate emails?
Simple Google Apps Script automations can be quoted as a custom offer.
Do you use AI?
I use AI-assisted tools to draft formulas and documents. I build, test and check everything for your process myself. Tell me before ordering if you would prefer no AI.
