Supplier onboarding tracker with a live dashboard by Charlotte UnderwoodSupplier onboarding tracker with a live dashboard by Charlotte Underwood

Supplier onboarding tracker with a live dashboard

Portfolio project
Charlotte Underwood
The brief (from a public job post): a small team onboarding new suppliers kept losing track of who was waiting on documents. They wanted one Google Sheet that flags problems by itself.
What I built: a Settings tab drives every dropdown (stage, owner, category, document status), so the team edits lists once and nothing breaks. A status column turns OVERDUE (red) when today passes the due date and the supplier isn't closed, and Due soon (amber) inside an adjustable window. The dashboard counts totals, overdue, due this week and average days to onboard, broken down by owner and category, with charts that update as rows are added.
How it was checked: formulas cover 500 rows and were tested against 12 sample suppliers covering every stage, then verified to calculate in both Excel and Google Sheets. A How-to tab means the team can run it without me.
Result: one screen that shows what's late and who owns it. Shown with fictional sample data; available as a template in my Contra shop.

0 likes · 0 views · Nov 20, 2026

Google Sheets / Excel tracker with automatic overdue flags and a live KPI dashboard (sample data).

Tags