How can I get a form to collect a Smartsheet Contact properly?
I have a Smartsheet with the field type set to "Contact List"
I have set up a form to feed into it.
If I set no validation then there is no dropdown box for users to choose from. Text input is collected as text, and not as the actual contact list.
If I set it to email, then the user must input an email address. This STILL doesn't collect the data as contact list info, but instead as an email - to convert it into a contact list entry the sheet user (me) needs to click into the cell, and confirm the name from the list which appears.
If I type an email address into the sheet manually it automatically detects the user from the contact list and inputs the data in the required format.
The desired outcome is for me users to be able to input a valid contact, and have it appear in my sheet as a proper contact list item - not an email address, and not plain old text. How can I achieve this please?