Google Sheets - Dependent Dropdown List for Entire Column - App Scipt, Run On User Input - Part 1
Why Stack Overflow recommends it
Stack Overflow users link it when answering how to build dependent or filtered in-cell dropdowns in Google Sheets with Apps Script instead of formulas.
Recommended by 2 people across 2 different months, 2018 to 2022.
What it is
A screen-recorded tutorial showing how to use Google Apps Script's onEdit trigger to apply data validation and build dependent dropdown lists across an entire column in Google Sheets. The example uses car makes and models, and this is part 1 of a series (the description points to an updated version).
What people said
Recommends Maxime Pacary · 2018-12 · Stack Overflow · on “Create in-cell dropdown with filtered range”
There is a solution [LINK] using Google Apps Scripts. Neat video explaining all the mechanisms involved: Part 1 [this video] Part 2 [LINK] Basically, by editing any cell on which your drop-down depends (e.g. Country for City list), for the related "City" cell it will automatically recalculate the range for validation data (list of possible Cities). Copy/pasting the script here just in case it becomes unavailable (that example used makes & models of cars for dependent drop-downs): function onEdit() { var tabLists = "lists"; var tabValidation = "Main"; var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var datass = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(tabLists); var ac
Recommends Shiva · 2020-06 · Stack Overflow · on “Google Sheets/Excel get named ranged name based on cell value with multiple rows for dependent dropdown”
What you are trying to achieve can be done in 2 ways it can be done 1) Via App Scripts WATCH THIS [this video] 2) Via Google sheets formula READ THIS [LINK]
Cites mr.dan · 2022-06 · Stack Overflow · on “How to get row index value from specific range”
I'm trying to follow this YouTube tutorial and it has already what I specifically need. It's a tutorial on GOOGLE SHEET - APPS SCRIPT. I'm trying to get the ROW NUMBER from a specified range. It's just that my data range of reference is vertical instead of horizontal. But when I try to edit the code, it returns an error value of -1. Could someone help me with this? Here is the YouTube link that I am following: [this video] Here's what I currently have. And if I understand correctly, the problem should be within lines 18 and 19 (see below). I could be wrong though. var makes = datass.getRange( 2, 2, datass.getLastRow(), 1).getValues(); var makeIndex = makes[0].indexOf(activeCell.getValue()); Will