Dynamic Dropdowns

I've been able to create and update 1500 dropdowns within seconds. I know a big issue in this community is wishing their is some way to update dropdown selections, with a small tweak to my javascript,

options array may not contain null elements.


const options = rows.map(x => x.cells.length && x.cells[0].displayValue)

.filter(x => x);

I was able to tag a 1500 sheets based on Sheet ID and Column ID Index: 0 - and now no longer need to worry about work around and time management for updates to those columns.