I am looking to validate that my field always starts with the following text before allowing it to be saved "inc", "sctask", "prb", "chg", or "ritm".

I have messed around with the LEFT and MID checks, but cant seem to combine multiple characters:

=AND(LEFT([Ticket Number],1)="i",(MID([Ticket Number],2,1)="n"))

Any help would be greatly appreciated!

1 Answer 1


Use this formula for column validation:

=OR(LEFT([Ticket Number],3)="inc",LEFT([Ticket Number],6)="sctask",LEFT([Ticket Number],3)="prb",LEFT([Ticket Number],3)="chg",LEFT([Ticket Number],4)="ritm")

Documentation: LEFT function

  • amazing! I am wondering if i could add a condition for when the field is blank? Currently for some specific list items i need to allow it to be blank as well. how would i do that? I am doing list validation stuff as well and it allows a blank value for certain options and requires info for others. Jul 26, 2022 at 16:21
  • I was actually able to use what you provided me to update the formula to allow blanks. =OR(LEFT([Ticket Number],3)="inc",LEFT([Ticket Number],6)="sctask",LEFT([Ticket Number],3)="prb",LEFT([Ticket Number],3)="chg",LEFT([Ticket Number],4)="ritm",LEFT([Ticket Number],3)="req",([Ticket Number]="")) Thanks for you help Jul 26, 2022 at 16:28
  • Great, glad it worked for you! Jul 26, 2022 at 16:59
  • Please Upvote(^) and accept as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily. Jul 26, 2022 at 16:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.