Enum Column and Google Sheets Data Validation

So I have a column called Company Name on a table called  Company PoC (Company Point of contact).

The Column Company Name is an Enum column who's values are given via a list provided through Data Validation on Googlesheets where the list of values is pulled from another sheet called Company under the column Company Name (The list of companies these Points of Contact could belong to).

My issue is, under Form View, I cannot assign my PoC's to any company! If I manually add the PoC on the sheet then select the company, that company will show up on the Form as an option. 

image0.jpeg

image2.jpeg

image1.jpeg

How do I fix this so all Companies show as an option on the form?

0 3 635
3 REPLIES 3
Top Labels in this Space