Drop down list of values

I think it can be done with CHOOSE function and some jQuery code which convert =CHOOSE(1,"Test1", "Test2") to drop down list

Drop-downs and other input widgets are currently not supported in cells. Keeping this as a feature request.

To clarify, CHOOSE(index, value1, value2, ...) allows to select a specific value from a list, given an index. It does not present a drop-down user interface.

Hi,

I am also looking for this functionality. Is there any update on this request please!

Thanks

I was able to use search autocomplete to produce an autocomplete drop down of suggestions for sheetnode. I used taxonomy to manage the list of values, then used a search autocomplete view to render the drop down on the sheetnode. See this issue which provides the necessary modifications to make this work. Attached is also an image that demonstrates the feature.

Search AutoComplete Issue