I have a issue with my data validation; my client requests a function: fetching data from the server and filling the response into the dropdown (requiring allow multiple selections). But when I use requireValueInList
to generate the dropdown, I can’t find any option to enable that. (I attached 2 images below)
const rule = SpreadsheetApp.newDataValidation()
.requireValueInList(['Yes', 'No'], true)
.build();
sheet.getRange(4, index + 1).setDataValidation(rule);
data validation created by app scripts
data validation created by data > data validation in menu bar
New contributor
Đắc Phú Huỳnh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.