Wonder if someone could help? I need to do a validation rule on the "Closed lost Reason" pick list value 'Gone to competitor', to then error message on the competitor field to fill in... would this need to be an IF statement?

Question

Wonder if someone could help? I need to do a validation rule on the  "Closed lost Reason" pick list value 'Gone to competitor', to then error message on the competitor field to fill in... would this need to be an IF statement?

adam marks · Answer

So when a user chooses Gone to Competitor as the list option you need to make sure they enter something into the Competitor field, right? Assuming so try this:

AND(
ISPICKVAL(Closed_Lost_Reason__c,"Gone to competitor"),
ISBLANK(Competitor__c)
)

Youi may need to tweak the field names if that's not their actual name.

Wonder if someone could help? I need to do a validation rule on the "Closed lost Reason" pick list value 'Gone to competitor', to then error message on the competitor field to fill in... would this need to be an IF statement?

Data Management

関連学習

さらにヘルプを表示