You need to sign in to do that
Don't have an account?
ANITHA 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
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
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
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 ) )
)
)