Dependent Drop-Down Lists For Googe Sheets v2022

  • Disable the auto-cleanup feature
  • Disable auto-complete feature
  • Delete following dependent values if the main is ‘bad’
// Advanced
{
sheet: 'Advanced',
dict: "'Ducks_Data'!A2:C",
first_row: 3,
first_column: 'A',
stop_autocleanup: true
},
{
sheet: 'Advanced',
dict: "'Ducks_Data'!A2:C",
first_row: 3,
first_column: 'E',
stop_autocomplete: true
},
{
sheet: 'Advanced',
dict: "'Ducks_Data'!A2:C",
first_row: 3,
first_column: 'I',
clear_notfound: true
},
{
sheet: 'Advanced',
dict: "'Ducks_Data'!A2:C",
first_row: 3,
first_column: 'M'
}

Source

  1. code: https://script.google.com/home/projects/1wsKkvdvnTkjMesolqwxc9nIow3QSbSn54ko8X0V8MustLgP6CKl-Lx25/edit
  2. sheet: https://docs.google.com/spreadsheets/d/1FVg-IBLTWhZJzRSivogCLexP2z2oorH-pg1LITjtduE/edit#gid=1278075736
  3. Github: https://github.com/Max-Makhrov/GoogleSheets/blob/master/other/dvl2022.gs
  4. Original story: https://max-makhrov.medium.com/dependent-dropdown-lists-in-google-sheets-v2021-eab0bd1d7670
  5. My page with projects: https://www.cooltables.online

Notes for search engine

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store