Validation rule based on Stage AND Opportunity Amount

Question

We have two custom fields called "Period of Performance" (number type) and "PO Amount" (currency type)

I would like make a validation rule that makes the user fill in the peroid of performance if the opp is won and if the PO value is over 250K.

If the opp is won and under 250K the Period of performance is not needed.

So far i have only been able to get it manditory when the opp is won I cant figure out how to pull in the PO Amount field. Here is what I currently have.

AND

(TEXT( StageName ) = "Closed Won",

ISBLANK( Period_of_Performance_months__c ))

Thank you for your help.

Kim

Deepak K Anand · Accepted Answer

Like this =  AND(     TEXT(StageName) = "Closed Won",     PO_Amount__c > 250000,     ISBLANK(Period_of_Performance_months__c) )

Validation rule based on Stage AND Opportunity Amount

Data Management

Risorse di formazione correlate

Ulteriore assistenza