You need to sign in to do that
Don't have an account?
dlatte
Help with Formula fields with nested OR condition
Advanced Formula question:
This formula works fine. It checkes the country is CN, or JP, or KR. Then it checks if any of the fields are blank. This works fine:
IF(OR (ISPICKVAL ( MailingCountryCode , "CN"),
ISPICKVAL(MailingCountryCode, "JP"),
ISPICKVAL(MailingCountryCode, "KR")),
(IF( ISBLANK( First_Name_Latin__c ) , 0, 1) +
IF( ISBLANK( Last_Name_Latin__c ) , 0, 1) + IF( ISBLANK( Job_Title_Latin__c ) , 0, 1) +
IF( ISBLANK( Department_Latin__c ) , 0, 1) + IF( ISBLANK( City_Latin__c ) , 0, 1) + IF( ISBLANK( Title ) , 0, 1) +
IF( ISBLANK( Department ) , 0, 1) + IF( AND(ISBLANK(Phone),ISBLANK(MobilePhone)), 0, 1)) / 8, 1)
My question:
The Title, Department, and (Phone,MobilePhone ) fields need to be check regardless of the Country.
How can I modify the above Advanced Formula for this?
The second condition is *not* dependent on the country, and only 3 fields are blank.
This formula works fine. It checkes the country is CN, or JP, or KR. Then it checks if any of the fields are blank. This works fine:
IF(OR (ISPICKVAL ( MailingCountryCode , "CN"),
ISPICKVAL(MailingCountryCode, "JP"),
ISPICKVAL(MailingCountryCode, "KR")),
(IF( ISBLANK( First_Name_Latin__c ) , 0, 1) +
IF( ISBLANK( Last_Name_Latin__c ) , 0, 1) + IF( ISBLANK( Job_Title_Latin__c ) , 0, 1) +
IF( ISBLANK( Department_Latin__c ) , 0, 1) + IF( ISBLANK( City_Latin__c ) , 0, 1) + IF( ISBLANK( Title ) , 0, 1) +
IF( ISBLANK( Department ) , 0, 1) + IF( AND(ISBLANK(Phone),ISBLANK(MobilePhone)), 0, 1)) / 8, 1)
My question:
The Title, Department, and (Phone,MobilePhone ) fields need to be check regardless of the Country.
How can I modify the above Advanced Formula for this?
The second condition is *not* dependent on the country, and only 3 fields are blank.
to be fair, off the top of my head (on a Friday afternoonb, right!) something like this would serve your need...
Though it could probably be done tidier than that I would imagine... that's not bad for free ;)
I will continue to work with the logic you provided, currently check syntax if failing:
Error: Incorrect parameter type for function 'OR()'. Expected Boolean, received Number
My logic is following the pattern I found in:
https://success.salesforce.com/answers?id=90630000000gidlAAA