Multiple Dependent Dropdown Lists on Every Line In Google Sheets with Google Apps Script 

Thanks so much, Vish!

Should be as simple as changing the 2 to a 5 in line 15

Absolutely. Here you go: script.google.com/d/15RAgd_BcsJM65T6ldiZ7FwCINzuAoCX3kzGWjEFsgs8c46I_SVfJ5XTG/edit?usp=sharing

@@HashAliNZ Thank you so much! btw this is the best video I've seen so far on this topic!

Hi Stefania onEdit functions aren't made to be run using the Run button in Apps Script. When you make a change within the spreadsheet at your target cells then it should work

@@HashAliNZ Thank you for your fast reply! I tried the run button because it didn't already work :( I've changed the sheets names, the edited column number and the data range address , the rest of the code is untouched, can't figure why it doesn't work :((

@stefania8715 feel free to share your code here. I'm not near a computer today so won't be able to get to it til later but could have a read through to see if I can spot any issues

@@HashAliNZ function onEdit(e) { const sheet = e.source.getActiveSheet(); const editedColumn = e.range.columnStart; const editedRow = e.range.rowStart; const dataRangeAddress = 'A2:C'; if (sheet.getName() === 'registrazioni') { const productsSheet = e.source.getSheetByName('dropdownData'); const dataRange = productsSheet.getRange(dataRangeAddress).getValues(); const columnOffset = productsSheet.getRange(dataRangeAddress).getColumn() - 1; const maxColumnIndex = productsSheet.getRange(dataRangeAddress).getLastColumn() - columnOffset; clearDropdowns(sheet, editedRow, editedColumn, maxColumnIndex + 1); if (editedColumn >= 5 && editedColumn < maxColumnIndex + 1) { const selectedValues = sheet.getRange(editedRow, 2, 1, editedColumn - 1).getValues()[0]; const nextColumnData = getNextColumnData(selectedValues, dataRange, editedColumn - 1); if (nextColumnData.length > 0) { const targetCell = e.range.offset(0, 1); var rule = SpreadsheetApp.newDataValidation() .requireValueInList(nextColumnData, true) .build(); targetCell.setDataValidation(rule); } else { e.range.offset(0, 1).clearContent().clearDataValidations(); } } } } function getNextColumnData(selectedValues, dataRange, columnIndex) { let filteredData = dataRange; for (let i = 0; i < selectedValues.length; i++) { filteredData = filteredData.filter(row => row[i] === selectedValues[i]); } const uniqueNextColumnValues = [...new Set(filteredData.map(row => row[columnIndex]))]; return uniqueNextColumnValues; } function clearDropdowns(sheet, row, startColumn, maxColumn) { for (let col = startColumn + 1; col

@@HashAliNZ I don't know how to show the code to you , I tried both pasting the code and sharing the link to the script but YB doesn't show the comments (at least I don't see them)