Smart-Data-Valigation-in-Goolge-Sheets

Create dependent drop-down lists in your sheets.

Setup

Open your Sheets
Go to menu Tools > Script Editor
Paste the code from here: https://github.com/Max-Makhrov/Smart-Data-Valigation-in-Goolge-Sheets/blob/master/Master.gs.
Reload the Google Sheets file
The new menu will appear at the right. Go to Smart Data Validation > Set/Update
The sample sheets will appear. See the work in the sheet "Work Sample". See setting in the sheet "Dv_Ini"
Have fun!

Set 2 and more level dependent drop-down lists (DDLs)
Set 1 and more DDLs on a single sheet.
Set 1 and more DDLs from single data sheet.
Set DDLs from another files as a source data.
Set DDLs in a custom order of columns.
Auto-complete values when the only value is left.
Auto-delete validation when user deletes values in previous level
When you set new rule, use auto column numbers detection. It works when column names are the same in source and work sheet.
Validation works when user copies data down (uses Ctrl + V or Ctrl + D keys).

Up to 500 values in a single DDL
Up to 50,000 calls / day. Limits are related to Google quotas: https://developers.google.com/apps-script/guides/services/quotas

Notes:

All *.gs liles from code source are modules in a project. Master.gs is a compressed version of all the files. It's made in order to reduce copy-paste work of installation.
If you want to see the code as it was developed, with all comments in a single file, please make a copy of this Google Sheet: https://docs.google.com/spreadsheets/d/16hL0Ip9rN8SFHkinBbN-1xUSfUQu5aKvdA2rEgOWSFM/copy. Open > Go To File > Make a Copy

Notes: