Update dropdown list in Google Sheets dynamically based on previous dropdown choice: Data Validation

00:00 Intro 00:16 Demo example 01:23 Why using relative cells is not a great option 01:44 Add a 'Notes' Google Sheets tab 02:24 Designing the input data 02:33 Getting a unique list of items 03:13 The item selector dropdown setup 03:39 Create a dynamic option list in 'Notes' 04:39 Create a dynamic dropdown list 05:00 Wrap up

You can grab the starter file here: https://yagisanatode.com/2021/01/26/the-monster-guide-to-data-validation-in-google-sheets-free-course/#Update_dropdown_list_in_Google_Sheets_dynamically_based_on_previous_dropdown_choice

In this tutorial, we cover how to create a dropdown list that is generated dynamically from the choice of another dropdown in Google Sheets using Data Validation.

We'll be using a number of Google Sheets Functions to achieve this including: FILTER https://yagisanatode.com/2020/02/15/google-sheets-how-to-use-or-inside-a-filter/ https://yagisanatode.com/2019/10/05/google-sheets-counting-and-filtering-rows-where-cells-contain-particular-values/ UNIQUE SORT

Here is a link to the accompanying post The Monster Guide to Data Validation in Google Sheets, it has more explanations and links to resources for you! https://yagisanatode.com/2021/01/26/the-monster-guide-to-data-validation-in-google-sheets-free-course/

#GoogleSheets #Spreadsheets #SpreadsheetBasics #GoogleEDU #GoogleWorkspace

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

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/

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 ... https://www.youtube.com/watch?v=VW3mhsFfzG0