A new knowledge base article has been published on our support portal.
In this scenario, we want to assign Ownership of an Opportunity depending of the amount of revenue that has been estimated.
We will create a formula that assigns an Opportunity to our Big Opportunity Sales Team for any Opportunity that has an Est Revenue greater than 1 million euro.
This formula will also assigns the Opportunity to our Small Opportunity Sales Team for any Opportunity that has an Est Revenue less than 1 million euro.
Note 1 : For this example you will need to have two teams called Big Opportunity Sales Team and Small Opportunity Sales Team setup beforehand.
They will need to have sufficient access to own an Opportunity record – the role Sales Manager will give them this.
N52 Formula Manager Solution
The Formula Manager solution works like this:
- A formula of type ‘Save – Perform Action’ is created on the Opportunity entity
- This Formula will be triggered whenever an Opportunity is created or the Est. Revenue field is updated
- The formula will assign the Opportunity record to the revenant Team depending on the value of the Est Revenue field.