Sign Up ›
  • Cullen Combs 1
  • NEWBIE
  • 10 Points
  • Member since 2016
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 1
    Replies
1 replies

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?
SOLVED
3 replies

I'd like to populate a Date formula field based off of a Text value in a Picklist.

I'd like to leverage the selected value from a Picklist containing the Text version of the twelve months.
Something like:
IF(
ISPICKVAL(Primary_Review_Month__c, "January"), 01/01/2017

I have tried CASE statements and IF statements and I have tried concatanating numerical values and all my attempts have all failed.
Any suggestions or something like this?
 
SOLVED
3 replies

I'd like to populate a Date formula field based off of a Text value in a Picklist.

I'd like to leverage the selected value from a Picklist containing the Text version of the twelve months.
Something like:
IF(
ISPICKVAL(Primary_Review_Month__c, "January"), 01/01/2017

I have tried CASE statements and IF statements and I have tried concatanating numerical values and all my attempts have all failed.
Any suggestions or something like this?