You need to sign in to do that
Don't have an account?
PubNoah
Validation Help
I am having a big problem with this validation rule. What am I doing wrong?? I want the validation to require that when "Demand Partner Numbers is selected in the picklist, both the DP Reporting Login URL and the DP Login Credentials fields are required. Validation below.
=======
IF(
AND(
ISPICKVAL(Billing_Based_On__c,"Demand Partner Numbers"),
OR(
ISBLANK(DP_Reporting_Login_URL__c)),
ISBLANK(DP_Login_Credentials__c)),
TRUE,
FALSE
)
AND(
ISPICKVAL(Billing_Based_On__c,"Demand Partner Numbers"),
OR(
ISBLANK(DP_Reporting_Login_URL__c),ISBLANK(DP_Login_Credentials__c))
)
This returns true when Demand Partner numbers is selected and if any of the other two fields is blank
(tat makes both the fields mandatory)
Let me know if this helps
--Satya
All Answers
AND(
ISPICKVAL(Billing_Based_On__c,"Demand Partner Numbers"),
OR(
ISBLANK(DP_Reporting_Login_URL__c),ISBLANK(DP_Login_Credentials__c))
)
This returns true when Demand Partner numbers is selected and if any of the other two fields is blank
(tat makes both the fields mandatory)
Let me know if this helps
--Satya
Try this validation to achieve your requirement :
ISPICKVAL(Billing_Based_On__c,"Demand Partner Numbers") && (OR(ISBLANK(DP_Reporting_Login_URL__c),ISBLANK(DP_Login_Credentials__c)))
Great! Thank you. This worked!
Please mark this question solved by clicking "Accept as Solution" button.
Hey PubNoah,
Good to know that u got the solution.
Did u try my solution too, it worked for me so just curious if the expression was as required :-)
Pradeep's formula is much better and cleaner.