+ Start a Discussion
roysmith601.3493067652527424E1roysmith601.3493067652527424E1 

question about validation rule on custom object

Hi,

I create a custom object "opp product"  and the reuirment is below:

field # 1: Process (which is flied date)

field # 2 : closing stage (which is pick list )

field # 3 = closing stage owner  (which is lookup field on oppportunity)

the reuirment is that if the processing filed had no date picked and closing stage = close complete then closing stage owner  should be null.

I am not sure that how to write a validation rule for this.

please help me and i am new to salesforce.

thanks

 

phiberoptikphiberoptik

Please post your question only once. I see that this was posted twice again.

 

AND(
    ISBLANK(Process__c),
    ISPICKVAL(Closing_Stage__c, "Close Complete"),
    NOT(ISNULL(Closing_Stage_Owner__c)
)

 

This rule will fire an error if the Process field is blank, the Closing Stage is "Close Complete, and the Closing Stage Owner has a value. Otherwise, if any of these is false, then the rule will not fire.

Steve MolisSteve Molis

+100 phiberoptik

 

 

Seriously!  between the Answers Forum and the Formulas Board you're practically SPAMMING with the same questions over and over.

AshesAshes

Hi,

 

Validation Rule is not a proper option for this scenario.

You have to go by either workflow or trigger.

 

Regards,

Ashes