Can a form open the Smartsheet Contacts List like the sheet does on a contact list field?

Matt Rasmussen

When a Contact List column type is used in a sheet, the dropdown arrow opens the Smartsheet Contacts List to choose the relevant person. The form uses email validation on that same field but it doesn't open the Smartsheet Contacts List like the sheet. The email validation requires the form user to type a valid email address format, but it doesn't verify that the email address actually exists. Is there a way the form can open the Smartsheet Contacts List like the sheet does? If not, how do we get the proper company staff info in the field when users only enter data from the form? We want Smartsheet automation to immediately notify staff that have been entered in the various fields.

Here's a screenshot the Smartsheet Contacts List in the sheet. Notice the top row has an email address for Michael Jordan that was entered on the form. I guarantee you Michael Jordan doesn't work at my company. 😜 Any way to get this list to work on the form?

Andrée Starå

Hi @Matt Rasmussen

I hope you're well and safe!

Unfortunately, it's not possible now to get the contact list in a form (security reasons), so you'd have to add them as selectable in the list.

FYI, I saw that Smartsheet is exploring to make it possible to include a group so everyone in the group would be selectable.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Matt Rasmussen

Thank you @Andrée Starå for your answer.

Andrée Starå

@Matt Rasmussen

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!