Creating a Dynamic Dropdown List in Google SpreadSheets via Script
Goto sheets.google.com - I saved this spreasheet as Temp.
Now click on the Extensions > App Script in the top-level menu as shown here :
Now, you'll see an editor like this below :
Now enter this code as is :
function onOpen()
{
dynamic_dropdow...
anjanesh.dev1 min read