+ Start a Discussion
rajesh k 10rajesh k 10 

How to add below brocess bulder criteria in "Formula Evaluation to ture"

Need small help on this
 
1)Account.Lob contains multiselect itest1
 
2)Account.Lob contains multiselect itest2
 
3)Account.Type equals field reference Account.Type
 
4)Account.Type does not equals  PP
 
5)Account.Type does not equals GP
 
Using ISNew how to add above criterias in Formula evaluation true critera in process builder decision box

Thanks 
 
Sanjay Bhati 95Sanjay Bhati 95
Hi Rajesh k

Here is your answer
 IF(
    AND(OR(CONTAINS( Accoun.Lob, 'itest1'),CONTAINS( Account.Lob,'itest2')),(OR(Account.Type<> 'TP',Account.Type <> 'GP'))),
    '',
    ''
)

Thanks
rajesh k 10rajesh k 10
Thanks Sanjay for the response.

Is this correct ?I have added ISNEW()

 IF(
    AND(ISNEW(),OR(CONTAINS( Accoun.Lob, 'itest1'),CONTAINS( Account.Lob,'itest2')),(OR(Account.Type<> 'TP',Account.Type <> 'GP'))),
    '',
    ''
)

And also If I have below scenario

1)Account.Lob contains multiselect itest1
 
2)Account.Lob contains multiselect itest2
 
3)Account.Type equals  PP

IF(
    AND(ISNEW(),OR(CONTAINS( Accoun.Lob, 'itest1'),CONTAINS( Account.Lob,'itest2')),(OR(Account.Type='PP'))),
    '',
    ''
)
 
 
Sanjay Bhati 95Sanjay Bhati 95
Hi Rajesh k,

Yes, This one is correct.