+ Start a Discussion
scottyscotty 

Rule to check value from account in an opportunity

I am trying to create a formula that will check the values (multi select) in the account object, as they would relate to a single value in  the Opportunity object.  I have 82 values in my multi select list to compare between the account and the opportunity.  here is a sample scenario,

 

Franks Auto Sales is my Account

Boston exists in my auction field in the opportunity.

Registered Auctions field is in the Account object (Multi Select)

 

When this account becomes registered with Boston, meaning that Boston would be included in the registered auction field, the Opportunity stage would be updated to Closed Won.

 

forcedotcomforcedotcom

I think you should be looking at Workflow rules (Field Updates) rather than Formulas & Validation Rules