Validate Column Data Received in a Form

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

First Name

Last Name


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?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!