---
title: "Dependent dropdown lists for Google Sheets (and lots of other Google Apps Script goodies)"
author: "Martin Hawksey"
date: 2022-07-18T20:59:14+00:00
modified: 2022-07-18T20:59:29+00:00
canonical_url: https://pulse.appsscript.info/p/2022/07/dependent-dropdown-lists-for-google-sheets-and-lots-of-other-google-apps-script-goodies/
markdown_url: https://pulse.appsscript.info/p/2022/07/dependent-dropdown-lists-for-google-sheets-and-lots-of-other-google-apps-script-goodies.md
categories:
  - "Intermediate"
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "@max__makhrov"
  - "max-makhrov"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2022/07/dropdown.gif
description: "If you are looking for a nice solution to build dependent drop-down lists in Google Sheets this is a great solution from Max Makhrov. For more experienced Google Apps Script developers the solution incorporates some clever snippets both from Max and a number of other members of the community. Some highlights include: converting a column index into corresponding column letter; a tasker to batch apply updates to a Google Sheet; ChuckyCache for objects above 100Kb; and a reference to a zip compression solution. All these are referenced in the source code provided in the post."
---

# Dependent dropdown lists for Google Sheets (and lots of other Google Apps Script goodies)

![Dependent dropdown lists for Google Sheets (and lots of other Google Apps Script goodies)](https://pulse.appsscript.info/files/2022/07/dropdown.gif)

> Updated the script for dependent lists, and now it supports new options. New for 2022:
> Dependent drop-down lists can be used to create a dynamic list of choices in Google Sheets. When the user makes a selection from the first drop-down list, the choices in the second drop-down list will be updated based on the selection. This can be used to create a cascading list of choices.

If you are looking for a nice solution to build dependent drop-down lists in Google Sheets this is a great solution from Max Makhrov. For more experienced Google Apps Script developers the solution incorporates some clever snippets both from Max and a number of other members of the community. Some highlights include: converting a column index into corresponding column letter; a tasker to batch apply updates to a Google Sheet; ChuckyCache for objects above 100Kb; and a reference to a zip compression solution. All these are referenced in the source code provided in the post.

Source: *[Dependent Drop-Down Lists For Google Sheets v2022*](https://max-makhrov.medium.com/dependent-drop-down-lists-for-googe-sheets-v2022-8dee6ae8e1f0)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/07/dependent-dropdown-lists-for-google-sheets-and-lots-of-other-google-apps-script-goodies/](https://pulse.appsscript.info/p/2022/07/dependent-dropdown-lists-for-google-sheets-and-lots-of-other-google-apps-script-goodies/)*