Work with me: Smart Habit Tracker Template: In this video, I show you step by step how to make an interactive and dynamic dashboard in google sheets. Shop my Templates: Follow my socials! SheetGeek TikTok: @sheetgeek SheetGeek Instagram: Instagram: 0:00 Intro 0:37 Dashboard Walkthrough 3:12 Download Dashboard 3:30 Step 1: Starting from Blank Sheet 7:21 Step 2: Writing the Habits 10:23 Step 3: Inserting the Checkboxes 14:28 Dynamic Day name & numbers 25:43 Step 4: Progress Bar & Percentage 37:02 Simple Conditional Formatting 39:55 Adding the Scorecards 46:30 Adding the Piechart 51:20 Adding the Area Chart #1 57:50 Adding the Area Chart #2 1:12:00 Advanced Conditional Formatting 1:19:44 Outro