Create a Dynamic Dropdown Dashboard with IMPORTRANGE in Google Sheets

The starter sheet: https://docs.google.com/spreadsheets/d/1sAtkjEDh-FTubW0qZHITpee-8Qx-fJbHtqO02-ZIAvA/copy Easter Eggs 🥚 and bonus useful formulas for the curious inside. The written tutorial: https://yagisanatode.com/2022/05/11/filtering-importrange-data-in-google-sheets/ The IMPORTRANGE series: https://www.youtube.com/playlist?list=PLSDEbLgMgqvoRJ-e9Sd4UXKxILIQCpzDr Learn how to create a dynamic dropdown dashboard to using IMPORTRANGE data in Google Sheets. In this tutorial, we will extract Sales data from another Google Sheet and create a Company and Sales Rep dropdown so we can quickly see what sales a rep is making for a company: 00:00 Intro. What we're building. 00:49 How to get the source Google Sheet 01:12 The basic formula. If you want to start from where we left off in the last tutorial you can grab the starter Google Sheet here: https://docs.google.com/spreadsheets/d/1I7o8IQj-r02-hxifJAiYhD8HULx-cVuLwtNAcGlPWKk/copy 07:50 Change Company & Rep to be drawn from cell data. 09:49 Create imported company dropdown 13:43 Create imported sales rep dropdown 15:43 Improving the sales dropdown list to match the company If you like the video, check out my website: https://yagisanatode.com/ Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/ Get your copy of the Google Sheet Project Task Manager here: yagisanatode.teachable.com/p/google-sheets-project-tasks-manager Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450 #GoogleSheets #Spreadsheets #GoogleEdu #administration #GoogleWorkspace