function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Phillip Moseley 2Phillip Moseley 2 

On the Main Sales New Record Type, when Estimated ACV is > 0 or when Estimated Services is > 0 do not allow the opportunity to move to a Closed/Won Status.

On our Main Sales New Opportunity Record Type, when Estimated ACV is > 0 or when Estimated Services is > 0 do not allow the opportunity to move to a Closed/Won Status.

So formula would need to have:
If Opportunity Record Type = Main Sales and the field Estimated ACV > 0 and the field Estimated Services > 0 then don't allow opportunity to move to Stage Closed Won.

I appreciate help creating this validation rule. 
Best Answer chosen by Phillip Moseley 2
PriyaPriya (Salesforce Developers) 
AND (
RecordType.DeveloperName  = "Main Sales",
OR(
Estimated_ACV__c >0,
Estimated_Services__c > 0),
ISPICKVAL(StageName, "CLosed Won"))

Please try the above.

Please mark it best answer if it works for you.

Regards,

Priya Ranjan

All Answers

PriyaPriya (Salesforce Developers) 
AND (
RecordType.DeveloperName  = "Main Sales",
OR(
Estimated_ACV__c >0,
Estimated_Services__c > 0),
ISPICKVAL(StageName, "CLosed Won"))

Please try the above.

Please mark it best answer if it works for you.

Regards,

Priya Ranjan

This was selected as the best answer
Phillip Moseley 2Phillip Moseley 2
Thanks Priya, this worked for me.