No restrict to dropdown values on form

Jonathan Vo

On the sheet, if I dont check on "Restrict to dropdown values only", then I can type a new value into the dropdown column. But on the form, I cannot type a new value, even I choose not to check "Restrict to dropdown values only" on the column properties. Is there any way that I can create a dropdown field on form and still allows users to enter value?

Chris McKay

Hi Jonathan,

Nope. Why you see is what you get unfortunately.

What you could do though is provide the dropdown as you've described along with an "other" text field and help text giving your users some idea that if the required value is not in the dropdown they can use the text field.

In your destination sheet, create a third column with the following formula:

=IF(LEN(Dropdown1) >0, Dropdown1, IF(LEN(Other1) >0, Other 1, ""))

I know it's not ideal, but probably the best you can do in the situation.

Kind regards,

Chris McKay