Validate Column Data Received in a Form

Donna T

I have created a simple form to collect the following fields of data:

First Name

Last Name

Email

ID number

Because a lot of times people are entering information into a form from a mobile device and sometimes have "fat fingers," I wanted to validate the ID column (with a list of users and IDs on another smartsheet).

What would the be the best way to accomplish this?

Thanks,

Donna

Andrée Starå

Hi Donna,

I’d recommend a combination of INDEX/MATCH.

More info:

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Donna,

I’d recommend a combination of INDEX/MATCH.

More info:

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!