You need to sign in to do that
Don't have an account?

please help in 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
All Answers
The formula expression is invalid: Field Opportunity is a picklist field. Picklist fields are only supported in certain functions.
For <3 years
For = 3 years
For > 3 years