Logically, I want to say:

IF status = 'Onboard' && ( startDate is Null || endDate is Null ) Then error out the record.

Or in other words, both date fields must be populated if status = 'Onboard'.

Now taking that and getting the right validation logic has caused me problems. Whatever code I have used, I have

either got a situation where both dates are populated and it still won't let me save, or it lets me save if none of the

dates are there.

This was the last one I tried.

AND( OR( CONTAINS(TEXT(Site__r.Status__c),"Onboard"), AND ( NOT(ISNULL( MACD_Start_Date__c )) , NOT(ISNULL( MACD_End_Date__c )) ) ))

Thanks for any help.

Logically, I want to say:

IF status = 'Onboard' && ( startDate is Null || endDate is Null ) Then error out the record.

Or in other words, both date fields must be populated if status = 'Onboard'.

Now taking that and getting the right validation logic has caused me problems. Whatever code I have used, I have

either got a situation where both dates are populated and it still won't let me save, or it lets me save if none of the

dates are there.

This was the last one I tried.

AND( OR( CONTAINS(TEXT(Site__r.Status__c),"Onboard"), AND ( NOT(ISNULL( MACD_Start_Date__c )) , NOT(ISNULL( MACD_End_Date__c )) ) ))

Thanks for any help.

Fellow members of the force !

I'm in dire need of a validation rule that does the following:

only allow values of 0,10,20,40,60,80,100 % in the probabilities field

and release the hounds of hell (error message) if someone enters

something else.

I tried ...

OR(

probability=0, probability=10 .. etc...)

then I tried 

NOT(

OR( ... same thing ... )

Any help much appreciated !!!!

Thanks in adavnce !!!