Validating a column with formula COUNT


Hi team -

I have an ID column that needs to have 18 characters (collected via a form), typically someone filling out the form will include a 16-character ID that breaks our automation and their input is not captured (lots of automation rows moving based on criteria, etc.)

I'm thinking that there's a way to use COUNT formula to say something like count characters, if blank after 16 characters, then show "Validation Failed" otherwise leave blank.

Help build this would be appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!