Automated Project Tracker Redesign (Before
Anaol Megersa
Automated Project Tracker Redesign (Before & After)
Rebuilt a cluttered, manual tracking spreadsheet into a high-performance, automated business dashboard.
Key Enhancements Implemented:
*Formula Optimization: Replaced broken hardcoded text values with dynamic =DUE_DATE-TODAY() logic to automatically display real-time overdue statuses.
*Data Synchronization: Automated row behaviors so clicking the "Done" checkbox instantly changes the workflow status to "Completed".
*UI/UX Visual Overhaul: Removed default system gridlines, applied a professional dark header theme, and center-aligned columns to minimize user visual fatigue.
Like this project
Posted Jul 19, 2026
Automated Project Tracker Redesign (Before & After) Rebuilt a cluttered, manual tracking spreadsheet into a high-performance, automated business dashboard. K...
Likes
0
Views
0
