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](https://www.salesmate.io/blog/wp-content/uploads/2022/05/Functions@2x-1-975x1024.jpg)
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](https://www.salesmate.io/blog/wp-content/uploads/2022/05/Deal-Value-1@2x-1-975x1024.jpg)
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](https://www.salesmate.io/blog/wp-content/uploads/2022/05/Deal-Value-2@2x-975x1024.jpg)
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](https://www.salesmate.io/blog/wp-content/uploads/2022/05/Edit-Field@2x-975x1024.jpg)
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?
Supercharge Your Sales Today! 🌟
- Save at least 50% on subscriptions and integrations
- Increase your conversion rates by 300%
- Choose a CRM trusted by 8500+ businesses
![salesmate CRM](https://www.salesmate.io/blog/wp-content/uploads/2024/06/home_banner@2x.png)
Close deals faster with the CRM designed for sales success.
You may also enjoy these
August 2024 Release Notes
We’ve been hard at work, listening to your feedback and thinking about how to make Salesmate even better for...
3 Min readSalesmate’s July 2024 Updates: Enhancing Your CRM Experience!
As part of our continuous commitment to improving your experience with Salesmate, we are thrilled to announce a...
4 Min read🚀 May 2024 Experience Updates: Ticket Management, SLAs, and Document Management are here!
This May is pretty special for us and our customers. We are adding two big features to Salesmate and also bringing...
4 Min readMarch 2024: All new Instagram integration, chat reports, and more!
In our tailored webinar on Salesmate 3.0, we already announced how we see social media integrations. We believe...
3 Min read🚀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
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.