+ Start a Discussion
lburnslburns 

Field Required for a Probability >30...current formula makes all required

Hello,

 

This is basically what I'm trying to do, but it makes all probabilities demand the Acceptance Date field be populated..I only want it at 40% above.  What is missing?

 

OR
       (Probability > 30,
    ISNULL( Acceptance_Date__c )
)

 

Thanks...

Message Edited by lburns on 03-23-2010 07:02 AM
Steve :-/Steve :-/

Try making it an "AND" also you should use a >= and your exact trigger threshold. 

 

AND((Probability >= 0.40),ISNULL(Acceptance_Date__c))

 

 

 

 

 

lburnslburns
That does it..thanks!
Steve :-/Steve :-/

No problem, you just owe me one of these

 

http://beeradvocate.com/beer/profile/863/7971/

 

Cheers!