Skip to main content
Jonathan White (Salesforce) 님이 #Data Management에 질문했습니다
Created this formula but getting an error can you help:

 

AND(

 

TEXT(Case_Type__c) ="Software Issue",

 

OR(

 

ISPICKVAL(Type , "Markes Software")

 

ISPICKVAL(Type, "Third Party"),

 

))
답변 6개
  1. 2016년 10월 19일 오전 11:56
    Hi Jonathan,

     

    Please try the below

    AND(

    TEXT(Case_Type__c) ="Software Issue",

    TEXT(Type) <> "Markes Software",

    TEXT(Type) <> "Third Party"

    )

    You could alos use CASE function as below to make the formula more efficient i.e. not repeatedly referencing the Type field in the formula

     

     

    AND(

    TEXT(Case_Type__c) ="Software Issue",

    CASE(Type,

    "Markes Software",1,

    "Third Party",1,

    0)=0

    )

     

     
0/9000