Validating a column with formula COUNT

Nataly Allimonos

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!

Nataly Allimonos

Solved it using LEN instead !

=IF((LEN([Opp ID]@row) > 17), "", "Incorrect ID")