Of course you can still enhance the formula above to check if the 2 characters do not contain :įor a picklist field, use TEXT( picklist_field_name) to convert a picklist value into a text value so that you can work with the value in functions that support text value. But, it still return TRUE for :N or V: and other any 2 character EXACT match of each state "CA:NV:FL:NY" This formula will ensure that BillingState is 2 characters in length. NOTE: when using contains with the multiple operator (:) contains then becomes equals.ĪND(LEN(BillingState)=2,CONTAINS("CA:NV:FL:NY",BillingState)) Return TRUE if BillingState is CA or NV or V:F or L or FL:NY or any exact match of "CA:NV:FL:NY". Return TRUE if Address values such as 1, 2, 9, 01, 789, or any other substring of "0123456789"Įxample: CONTAINS("CA:NV:FL:NY", BillingState) Returns TRUE if "BadWord" is found anywhere in Comments_cĢ. Check if an unknown string or character matches a defined set of strings or characters.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |