How can allow entry below both bold texts.
AND(or(
startswith([PUTWAY NO],"PUT"),
startswith([PUTWAY NO],"FBF SMART"),
startswith([PUTWAY NO],"ADJUST_DONE")
),LEN([PUTWAY NO]) =8
Your logic is broken. You cannot enforce an 8-character field length and at the same time be looking for fields that start with a pattern of 8+ characters.
Give me suggestion
How can I do that.
Already told you. YOUR logic is broken.
You want to allow a word that begins with an 11-Character pattern. AND at the same time you want to allow only words with a length of 8 characters.
You want to allow animals that are larger than a cow and are of the same size exactly as a dog.
I don't know how you can do that.
I know this too.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |