How to Build a Project Management Template in Google Sheets (Project Milestone Tracker) and Excel

Purchase template here: hustlesheets.samcart.com/products/product-manageme… Book a consultation call here: clarity.fm/hustlesheets Automatically connect marketing data such as FB Ads to Google Sheets here: supermetrics.com/?idev_id=2372 Watch and learn how to build this project management tracker (easily track project milestones) in Google Sheets. I am using a solar sales business as my example. This is similar to a Gantt chart. Chapters: 0:00 Intro 2:39 Step 1: Determine your project steps 4:58 Step 2: Set # of days between each step 7:44 Step 3: Create basic columns 10:08 Step 4: Dropdowns 15:25 Step 5: Status logic mapping 21:56 Step 6: Write first status formula 39:09 Step 7: Status formula for other steps 49:17 Step 8: Conditional formatting 57:18 Step 9: Formatting / Scorecards 1:00:30 Bonus: Notes tips 1:02:28 Bonus: How to sort