Skip to main content
Topics#Data ManagementAdriana Smith의 질문
Adriana Smith (TWG Plus) 님이 #Data Management에 질문했습니다
2017년 1월 12일 오후 7:59

Syntax error on Validation Rule help

Trying to create a validation rule where an opportunity can only be created through a lead conversion if the opp type field= New, Upsell.  Here's my rule:

 

AND(

 

ISPICKVAL(Type , "New", Upsell"),AND( Converted_from_Lead__c = false)

 

It's not working... Help?
답변 9개
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2017년 1월 12일 오후 9:17
    My bad, I though you wanted it on Renewals, here you go

     

     

    AND(
    ISNEW(),
    CASE(Type,
    "New" , 1 ,
    "Upsell" , 1 ,
    0 ) = 1 ,
    Converted_from_Lead__c = FALSE
    )

     

     
답변을 작성하세요...
0/9000