function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
gowtham kumar 14gowtham kumar 14 

IF Business Field Name = PS-BIOP NC, Product Family & Product Sub Family cannot be blank. Make those 2 fields required if Business Field name = PS-BIOP NC.

Hi all,
how to write the validation rule for above requirement, can you please help me on this ?
SwethaSwetha (Salesforce Developers) 
HI Gowtham,
Are Product Family and Product Sub Family custom fields on the same object?

Related examples: https://www.levelupsalesforce.com/salesforce-validation-rule-checkbox
https://salesforce.stackexchange.com/questions/275649/validation-rule-if-active-checkbox-in-unchecked-then-reason-for-cancellation-is

Thanks
gowtham kumar 14gowtham kumar 14
Yes Swetha
SwethaSwetha (Salesforce Developers) 
Try below validation rule 
AND(Name='PS-BIOP NC',OR(ISBLANK( Product_Family__c),ISBLANK( Product_Sub_Family__c)))

Replace the Name field with the API Name of Business Field Name.

If this information helps, please mark the answer as best. Thank you
gowtham kumar 14gowtham kumar 14
Hi Swetha,
if Business field Name is a formula field  then how to write , can you please help ?
Salesforce TechieSalesforce Techie
https://help.salesforce.com/s/articleView?id=sf.formula_field_limits.htm&type=5
SwethaSwetha (Salesforce Developers) 
The same syntax can be used considering Business_field_Name__c as formula 
AND(Business_field_Name__c='PS-BIOP NC',OR(ISBLANK( Product_Family__c),ISBLANK( Product_Sub_Family__c)))
Hope this helps!Thank you