I'm trying to create a drop down list... something i've never had an issue with until GSheets modified the route in which they handle dropdown lists. Now I cannot seem to get them to work. Have tried following tutorials to see if I've missed a change and still encounter the error.
To create the below error: I select the dropdown from the cell with the list and select one of the two options I've created from the data validation inset menu. Both of the options return a rejection response.