+ Start a Discussion
ANITHA BEEMU 2ANITHA BEEMU 2 

HI can anyone help on formula

i need a formula on process builder,with critriea opportunity stage closed won,Referral (custom field) not null and contract term <3 years

i have conterm term a picklist field with values 12,24,36,48,60,72 all in months

for <3 years one formula
for  3 years one formula and 
for 4+ years one formula

i tired following one,getting error:
AND( 
OR( 
ISPICKVAL([Opportunity].StageName , "Closed Won"), 
OR( 
 NOT ( ISBLANK ( [Opportunity].Referral__c )  ), 
OR( 
ISPICKVAL([Opportunity].ContractTerm__c <36 )) ) 
)
)


please help me in this

 
Best Answer chosen by ANITHA BEEMU 2
Vaseem SVaseem S

Can you please try this

AND( 
OR( 
ISPICKVAL([Opportunity].StageName , "Closed Won"), 
OR( 
 NOT ( ISBLANK ( [Opportunity].Referral__c )  ), 
OR( 
VALUE( TEXT( [Opportunity].ContractTerm__c ) ) < 36 ) ) 
)
)

All Answers

Raj VakatiRaj Vakati
AND( 
ISPICKVAL([Opportunity].StageName , "Closed Won"), 
 NOT ( ISBLANK ( [Opportunity].Referral__c ) ),
OR( 
ISPICKVAL([Opportunity].ContractTerm__c ,"12 ") , 
ISPICKVAL([Opportunity].ContractTerm__c ,"24 "),
ISPICKVAL([Opportunity].ContractTerm__c ,"36 ")
)
 
)

 
Vaseem SVaseem S

Can you please try this

AND( 
OR( 
ISPICKVAL([Opportunity].StageName , "Closed Won"), 
OR( 
 NOT ( ISBLANK ( [Opportunity].Referral__c )  ), 
OR( 
VALUE( TEXT( [Opportunity].ContractTerm__c ) ) < 36 ) ) 
)
)
This was selected as the best answer