+ Start a Discussion
John KeplerJohn Kepler 

Validation Rule to give error on certain criteria

Hi,

I am creating a validation rule to restrict user from entering amount less than 10000$ when industry type is Corporate. I am facing an error.

Any help will be appreciated.

Thanks

John 

Best Answer chosen by John Kepler
D srinivas 8734D srinivas 8734
Hi John,
AND(ISPICKVAL( Industry , 'Corporate'),amount > 10000)
 
   
copy above formula and paste in Validation rule ..
For more information please visit below link
https://www.etggs.com/services/salesforce/ (https://www.etggs.com/services/salesforce/" style="color:#0563c1; text-decoration:underline)

All Answers

AnudeepAnudeep (Salesforce Developers) 
Hi John, 

Can you provide additional details around the error you are getting and your rule criteria?

Anudeep
D srinivas 8734D srinivas 8734
Hi John,
AND(ISPICKVAL( Industry , 'Corporate'),amount > 10000)
 
   
copy above formula and paste in Validation rule ..
For more information please visit below link
https://www.etggs.com/services/salesforce/ (https://www.etggs.com/services/salesforce/" style="color:#0563c1; text-decoration:underline)
This was selected as the best answer
John KeplerJohn Kepler
@srinivas that did the trick but the amount is les than 10000$. amount<10000