You need to sign in to do that
Don't have an account?
Adrian-E
Simple Validation Rule
I seem to have gotten stuck!
I am looking to create a validation rule that will validate a field called ticket number:
The rule needs to check that the value:
1) begins with "LTK"
2) contains more than one number
3) ends with "X"
this is so simple, that I feel stupid asking...
:smileysad:
I am looking to create a validation rule that will validate a field called ticket number:
The rule needs to check that the value:
1) begins with "LTK"
2) contains more than one number
3) ends with "X"
this is so simple, that I feel stupid asking...
:smileysad:
If you have havent had a solution yet, this might help:
NOT(
AND(
Left(ticket_number_c,3)="LTK",
LEN(Ticket_Number_c)>5,
Right(ticket_number_c,1)="X"
)
)
Assuming ticket_number_c is your field name
Hope this helps,
Regards
Charly
Thanks!
That worked like a charm!