Utilize Copper's workflow automation to automatically calculate the total value of the Pipeline Record based on Product or Services that are added to the record. Below we'll cover two examples, the first example is with Fixed Prices, the second example allows for Variable Prices for each product or service.
Scenario 1: Products or Services with Fixed Prices
Understanding the Scenario
In this scenario, each product or service has a predetermined, unchanging price. Fixed pricing simplifies the value calculation, as the price remains constant.
Setting up the Required Fields and Workflow Automation
Before creating the workflow automation, first you need to create a number field for each of your products.
Create Custom Number Fields for each Product or Service you off
Create a Custom Number Field for each Product or Service you offer.
Ensure to add a Workflow Automation Formula Key (this will be used to calculate the Pipeline Record Value)
Example:
Service 1
Field Type: Number Field
Label: Service 1
Workflow Automation Formula Key: service1
Create Workflow Automation Rule to calculate the total value
Next we will setup a Workflow Automation to update the Value Field when either Product/Service Field is updated
Trigger: When a Any time a Pipeline record is Updated or Created
Trigger Conditions:
Product/Service Fields > 0
Action:
Goal: Total Value = (Product/Service 1 * Fixed Price) + (Product/Service 2 * Fixed Price)...
If a field is not filled in, the formula will fail, so we will use IF, ISBLANK*
When using custom fields, the variable name is "cf_[workflow key]"
Use the following Action:
Value - change to - Use a Formula - (IF(ISBLANK(cf_service1), 0, cf_service1) * 100) + (IF(ISBLANK(cf_product2), 0, cf_product2) * 300)...
In this example the price of Service 1 is $100, and the price of Product 2 is $300
Save and Enable the Automation
First, save the Workflow Automation, if the automation fails to save you may have an error in your Action Formula.
Second, use the Workflow Toggle and set to "ON"
Test the Workflow Automation
Update all or either of your Product/Service Fields on your Opportunity
Refresh your browser page and check if the Value field is calculated correctly.
NOTE: If you ever want to adjust the product price, you can do so by updating the workflow automation.
Scenario 2: Products or Services with Variable Prices
Understanding the Scenario
In this scenario, product or service prices vary based on factors such as:
Customized Pricing
Discounts
Seasonal pricing
etc.
Setting up the required Fields and Workflow Automation
Before creating the workflow automation, first you need to create a number field for each of your products.
Create Custom Number Fields for each Product or Service you off
Create a Custom Number Field for each Product or Service you offer.
Ensure to add a Workflow Automation Formula Key (this will be used to calculate the Pipeline Record Value)
Example:
Service 1
Field Type: Number Field
Label: Service 1
Workflow Automation Formula Key: service1
Create Custom Currency Fields for each Product or Service Price
Create a Custom Currency Field to capture the price for each Product or Service you offer.
Ensure to add a Workflow Automation Formula Key (this will be used to calculate the Pipeline Record Value)
Example:
Service 1 Price
Field Type: Currency Field
Label: Service 1 Price
Workflow Automation Formula Key: service1_price
Create Workflow Automation Rule to calculate the total value
Next we will setup a Workflow Automation to update the Value Field when either Product/Service Field or Product/Service Price Field is updated
Trigger: Anytime a Pipeline record is Updated or Created
Trigger Conditions:
Product/Service Fields > 0
or Product/Service Price Field > 0
Action:
Goal: Total Value = (Service 1 * Service 1 Price) + (Product 2 * Product 2 Price)...
If a field is not filled in, the formula will fail, so we will use IF, ISBLANK*
When using custom fields, the variable name is "cf_[workflow key]"
Use the following Action:
Value - change to - Use a Formula - (IF(ISBLANK(cf_service1), 0, cf_service1) * IF(ISBLANK(cf_service1_price), 0, cf_service1_price)) + (IF(ISBLANK(cf_product2), 0, cf_product2) * IF(ISBLANK(cf_product2_price), 0, cf_product2_price))...
In this example the price of Service 1 is multiplied by Service 1 price, and added to Product 2 multiplied by Product 2 price.
Save and Enable the Automation
First, save the Workflow Automation, if the automation fails to save you may have an error in your Action Formula.
Second, use the Workflow Toggle and set to "ON"
Test the Workflow Automation
Update all or either of your Product/Service Fields on your Opportunity
Refresh your browser page and check if the Value field is calculated correctly.
