A) I would like to create a Custom Formula Checkbox Field that marks as TRUE for the following logic:
Account Type is NOT = ABC, BED, HEY, NHD or JHD
B) Custom Formula Checkbox Field that marks as TRUE for the following logic:
Contact Title = Tier 1, Tier 2 or Tier 3
답변 2개
for first, considering picklist type:
NOT(
OR(
ISPICKVAL(AccountType, "ABC"),
ISPICKVAL(AccountType, "BED"),
ISPICKVAL(AccountType, "HEY"),
ISPICKVAL(AccountType, "NHD"),
ISPICKVAL(AccountType, "JHD")
)
)
for second:
if picklist type,
OR(
ISPICKVAL(Contact_Title__c, "Tier 1"),
ISPICKVAL(Contact_Title__c, "Tier 2"),
ISPICKVAL(Contact_Title__c, "Tier 3")
)
