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.
How do I fix this so all Companies show as an option on the form?
User | Count |
---|---|
23 | |
15 | |
4 | |
3 | |
3 |