💥 Reach thousands of inboxes in minutes: All new 'Email Campaigns' is here! - Learn More

Introducing Formula Fields in Salesmate: Calculate complex calculations automatically

Introducing Formula Fields in Salesmate: Calculate complex calculations automatically

This May, Salesmate is bringing Formula Fields, that’ll help you create custom formulas and use them for various sales, marketing, or customer service calculations or metrics. You must be familiar with Custom Fields in Salesmate. Consider Formula Fields as a high-level upgrade.

Let’s start with the basics.

So, what are Formula Fields?

Formula Fields are equation-based custom fields where you can combine functions, operators, and existing Salesmate fields, and create a formula of your choice to get answers to complicated calculations.

Salesmate Formula Fields

Now, Formula Fields works with the four most essential modules in Salesmate:

1. Contacts
2. Companies
3. Deals
4. Activities

Just to give a simple example, you want to calculate the discount amount for every deal you create.

You can create a simple formula like:

Deal Value*25%

Now, every time you open up any deal, you’ll find the discount amount calculated automatically.

I understand you might need more insight on how this feature can help you in real business scenarios.

So, we’ll take three perspectives – Sales, Marketing, and Customer Service. And see how Formula Fields can help each team.

Formula Fields for sales teams

Let’s assume you want to calculate commission for every deal your sales reps close. You can calculate sales commission in multiple ways, and every business has a different approach to it.

But for ease of understanding, let’s assume that you want to give 10% of the Deal Value as a commission to the rep.

Here’s how you can create a Formula Field for this use case:

First, go to “Manage Fields” from the New Deal option. Create a “New Custom Field” and choose the newly added “Formula” option at the very bottom.

This is the space where you’ll create a formula from scratch. You’ll find 40+ functions and operators here. You can also use your existing fields as a part of your equation.

So, this is the formula we can use to calculate the commission for each deal.

Salesmate Formula Field for Sales Teams

Once you make the formula live, you will see the new field active in every deal with the calculation you need.

Remember, Formula Fields are dynamic, and they work based on the equations you have set. So, if you change the deal value, you will notice the change in commission as well.

Formula Fields for marketing teams

Let’s try to broaden our vision for Formula Fields, and this time we will take an example for marketing agencies.

As an agency, you deal with a lot of freelance content creators, and you have to pay them every month based on how many words they have written.

We can ditch Excel for this task and automatically calculate the total amount you have to pay using Formula Fields.

First, we need to create two custom fields inside the Deal module.

1. Number of Words Per Article
2. Per Word Charges

Now, we will create a Formula Field, that’ll give me the total cost of each article, and the formula will go something like this:

Salesmate Formula Fields for Marketing Teams

By the end of the month, you can create a detailed report on how many words have been created by the writer and how much the total cost is.

This means Formula Fields is an amazing tool to supercharge your reports and performance tracking.

We can also take another example for the customer service teams.

Formula Fields for customer service teams

Let’s assume, we want to calculate the insurance policy renewal date.

First, we need to add a custom formula field of “Policy Start Date”.

Now, we will create a new custom field with a formula. It would look something like this:

Salesmate Formula Fields for Customer Service Teams

This formula will automatically calculate the next policy date, so your service team can connect with customers or use automation to shoot reminder emails.

There are tons of use cases, and Formula Fields can truly add value to your sales, marketing, and CX efforts. If you’d like to learn more about Formula Fields, check out our support article here.

Want to try it yourself?

Kashyap Trivedi

Kashyap Trivedi is working with an awesome marketing team at Salesmate CRM. He is deeply interested in learning digital marketing trends and try them out! When he’s not working, you’ll find him reading a good book or meditating.

You may also enjoy these

Product Updates
🚀January Experience Updates: 3 Key changes to kick-start 2024

Let's dive into 2024 with some amazing Salesmate updates and improvements. Check out the three top changes you'll...

2 Min read
Product Updates
📧 Reach thousands of inboxes in minutes: All new ‘Email Campaigns’ is here! 

If you’ve tried Salesmate before (or you’re an existing customer), you might know that our platform already...

3 Min read
Product Updates
April 2023: 5 Improvements in Contacts, Companies, Salesmate Chat & more 

April was a productive month for us. We took feedback from our customers on items that impact their daily...

2 Min read
Product Updates
🚀 Salesmate Experience Updates: 11 exciting things happened this March

A couple of important additions and improvements this month.   There’s no specific theme to this...

6 Min read
Product Updates
🚀 Salesmate Experience Updates: Changes in Automation Journeys & Reporting Widgets

Automation Journeys and Reports are among the essential features for our customers.  So, February is about...

4 Min read

Make sales sexy again 😉

  • Save at least 50% on subscriptions and integrations.
  • Save 30% more time for your sales team.
  • Choose a CRM trusted by 5000+ businesses.
salesmate CRM
Scroll to Top
Scroll to Top