You need to sign in to do that
Don't have an account?
SV 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
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: Hope this helps! Please mark as best answer if it does
Thanks
All Answers
Use below validation rule on Opportunity.
AND( Amount > 10000, NOT( TEXT(StageName) = 'Closed Won'))
Regards,
Uttpal Chandra
My question is..Is it possible to validate "Stage Name" picklist based on Amount filed in Opportunity object??
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: Hope this helps! Please mark as best answer if it does
Thanks