function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Cullen Combs 1Cullen Combs 1 

I'd like the following formula to evaluate to 'True' so that it can kick off a process builder:

OR(

ISPICKVAL([Account].Service_Package__c ,"AA") 
&&
[Account].Days_Since_Last_Touch_Point__c=60,

ISPICKVAL([Account].Service_Package__c ,"A")
&&
[Account].Days_Since_Last_Touch_Point__c=90,

ISPICKVAL([Account].Service_Package__c ,"B")
&&
[Account].Days_Since_Last_Touch_Point__c=180,

ISPICKVAL([Account].Service_Package__c ,"C")
&&
[Account].Days_Since_Last_Touch_Point__c=360
)


Does something need to be added before the OR( statement? I want the process to kick off if any of the the four scenarios are True.
Suggestions?
SalesFORCE_enFORCErSalesFORCE_enFORCEr
Use this 
OR(
AND(
ISPICKVAL([Account].Service_Package__c ,"AA"),
[Account].Days_Since_Last_Touch_Point__c=60),
AND(
ISPICKVAL([Account].Service_Package__c ,"A"),
[Account].Days_Since_Last_Touch_Point__c=90),
AND(
ISPICKVAL([Account].Service_Package__c ,"B"),
[Account].Days_Since_Last_Touch_Point__c=180),
AND(
ISPICKVAL([Account].Service_Package__c ,"C"),
[Account].Days_Since_Last_Touch_Point__c=360)
)