Skip to main content
Topics#Data ManagementFrage von Jonathan White
Jonathan White (Salesforce) fragte in #Data Management
19. Okt. 2016, 10:57

Error: Syntax error. Missing ')' on Validation rule

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 Antworten
  1. Sunil Sarilla (M&G Investments)
    19. Okt. 2016, 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
    )

     

     
Antwort schreiben...
0/9000