Sign Up ›
  • Nicholas Zorrilla 5
  • NEWBIE
  • 10 Points
  • Member since 2019
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
SOLVED
2 replies

Process Builder IF statement

I want to update a Picklist based on certain critieria. Here is the statement I wrote in Process Builder, the issue I am having is it won't update the picklist value to 'New' but instead goes to Null. Can anyone help? Thank you in advance.
Formula: 
IF([Partnership__c].Actual_Launch_Date__c < DATE(2019,1,1), 'Base',

    IF([Partnership__c].Actual_Launch_Date__c >= DATE(2019,1,1) && 
       [Partnership__c].Actual_Launch_Date__c <= DATE(2019,12,31) &&
       [Partnership__c].Merchant__c.Integration_Launch_Date__c < DATE(2019,1,1) &&
       [Partnership__c].Publisher__c.Integration_Launch_Date__c < DATE(2019,1,1)
    ,'Growth',
    IF(([Partnership__c].Actual_Launch_Date__c >= DATE(2019,1,1) && 
[Partnership__c].Actual_Launch_Date__c <= DATE(2019,12,31) &&
([Partnership__c].Merchant__c.Integration_Launch_Date__c >= DATE(2019,1,1) ||
[Partnership__c].Publisher__c.Integration_Launch_Date__c >= DATE(2019,1,1)))
|| 
([Partnership__c].Merchant__c.Integration_Launch_Date__c >= DATE(2019,1,1)  && [Partnership__c].Publisher__c.Integration_Launch_Date__c < DATE(2019,1,1)  )
||
([Partnership__c].Publisher__c.Integration_Launch_Date__c >= DATE(2019,1,1)  && [Partnership__c].Merchant__c.Integration_Launch_Date__c < DATE(2019,1,1)  ), 'New', '')
    )
) 
SOLVED
2 replies

Process Builder IF statement

I want to update a Picklist based on certain critieria. Here is the statement I wrote in Process Builder, the issue I am having is it won't update the picklist value to 'New' but instead goes to Null. Can anyone help? Thank you in advance.
Formula: 
IF([Partnership__c].Actual_Launch_Date__c < DATE(2019,1,1), 'Base',

    IF([Partnership__c].Actual_Launch_Date__c >= DATE(2019,1,1) && 
       [Partnership__c].Actual_Launch_Date__c <= DATE(2019,12,31) &&
       [Partnership__c].Merchant__c.Integration_Launch_Date__c < DATE(2019,1,1) &&
       [Partnership__c].Publisher__c.Integration_Launch_Date__c < DATE(2019,1,1)
    ,'Growth',
    IF(([Partnership__c].Actual_Launch_Date__c >= DATE(2019,1,1) && 
[Partnership__c].Actual_Launch_Date__c <= DATE(2019,12,31) &&
([Partnership__c].Merchant__c.Integration_Launch_Date__c >= DATE(2019,1,1) ||
[Partnership__c].Publisher__c.Integration_Launch_Date__c >= DATE(2019,1,1)))
|| 
([Partnership__c].Merchant__c.Integration_Launch_Date__c >= DATE(2019,1,1)  && [Partnership__c].Publisher__c.Integration_Launch_Date__c < DATE(2019,1,1)  )
||
([Partnership__c].Publisher__c.Integration_Launch_Date__c >= DATE(2019,1,1)  && [Partnership__c].Merchant__c.Integration_Launch_Date__c < DATE(2019,1,1)  ), 'New', '')
    )
)