I have a Sheet with a Contact List Column. The Values has about 80 Contacts for the Dropdown List.
If I build that Contact List Column into a Form then all 80 Contacts can be selected in the Form.
Once that Form has populated a Sheet Row, if I go into the Cell in the Contact list Column to change the Cell value then the Dropdown List seem to be limited to the first 50 Contacts and I cannot scroll down to select any of the last 30.
Is there a Setting to fix this?
Thanks
Andrew