In this post, I demonstrate How to Create Data Validation Drop-down List Using Google Apps Script on Google Sheets
How-to Video:
Video Notes:
- Legacy Apps Script Editor Used in Video
- Apps Script (Script Editor) is now located under the tab ‘Extensions’ instead of ‘Tools’ on Google Sheets
Code in Video:
//DEFINE ALL ACTIVE SHEETS
var ss = SpreadsheetApp.getActiveSpreadsheet();
//DEFINE MENU SHEET
var menuSheet = ss.getSheetByName("Menu");
var partSheet = ss.getSheetByName("Parts");
//PART DROPDOWN
var partCell = menuSheet.getRange('A4');
var partLastRow = partSheet.getLastRow();
var partRange = partSheet.getRange('A1:A' + partLastRow);
var partRule = SpreadsheetApp.newDataValidation().requireValueInRange(partRange).build();
partCell.setDataValidation(partRule);
Related Posts



















