Northern Trail Outfitters (NTO) wants to ensure new Contacts are validated before they can be saved. If a user selects that the LeadSource picklist value is Other, NTO also wants to populate a…

Question

Options

• AAND(LeadSource = 'Other', Source__c = '')
• BAND(NOT(LeadSource = 'Other'), NOT(Source__c = ''))
• CAND(ISPICKVAL(LeadSource,'Other'), ISBLANK(Source__c))
• DAND(NOT(ISPICKVAL(LeadSource,'Other'))), NOT(ISBLANK(Source__c))

• A
  4% (2)
• B
  15% (8)
• C
  73% (38)
• D
  8% (4)

Explanation

Salesforce validation rules fire (block the save) when the rule evaluates to TRUE. The requirement is: if LeadSource is 'Other' and Source__c is blank, block the save. Option C - AND(ISPICKVAL(LeadSource,'Other'), ISBLANK(Source__c)) - correctly uses ISPICKVAL() to compare a picklist field (direct equality '=' does not work reliably on picklists in formula context) and ISBLANK() to check if the text field is empty. This rule returns TRUE only when both conditions are met, correctly blocking the save. Option A uses = on a picklist (invalid). Option B inverts the logic, blocking saves when LeadSource is NOT Other and Source__c is NOT blank. Option D has inverted logic and a syntax error (extra parenthesis).

No community discussion yet for this question.