+ Start a Discussion
SV MSV M 

If amount is greater than 10000 then stage should allow closed won other wise throw an error, on opportunity

 If amount is greater than 10000 then stage should allow closed won other wise throw an error, on opportunity
Best Answer chosen by SV M
SarvaniSarvani
Hi Sai,

The formula first validates the stage name field. If the stage name is Closed Won then it will check if the amount is greater than 10000. If not it throws error. Therefore, Stagename ->Closed Won can only be selected if the amount is greater than 10000 or it throws error.

Please try below formula:
If( TEXT(StageName) == 'Closed Won', true,false) && 
If((Amount <10000),true,false)
Hope this helps! Please mark as best answer if it does

Thanks

All Answers

Uttpal_ChandraUttpal_Chandra
Hi Sai,

Use below validation rule on Opportunity.

AND( Amount > 10000, NOT( TEXT(StageName) = 'Closed Won'))

Regards,
Uttpal Chandra
 
SV MSV M
This is not working...
My question is..Is it possible to validate "Stage Name" picklist based on Amount filed in Opportunity object??
SarvaniSarvani
Hi Sai,

The formula first validates the stage name field. If the stage name is Closed Won then it will check if the amount is greater than 10000. If not it throws error. Therefore, Stagename ->Closed Won can only be selected if the amount is greater than 10000 or it throws error.

Please try below formula:
If( TEXT(StageName) == 'Closed Won', true,false) && 
If((Amount <10000),true,false)
Hope this helps! Please mark as best answer if it does

Thanks
This was selected as the best answer
SV MSV M
Thanks for your response and its working perfect....