monday.com partner logo
Monday.com work os
Tips, tricks and more for getting the most out of monday.com

How to Multiply or Add Numbers in a Formula Column in monday.com

When you have multiple numbers columns from which you need to do calculations on, doing calculations manually could be a chore. But the “Formula” column in monday.com makes it a breeze to perform calculations on your board to get all of the data that you need. 

Today, I’ll explain how to add and multiply numbers using the “Formula” column on monday.com. This function is available on the Pro and higher plans. So, make sure you are on the right plan.  This column can do a lot more complex calculations but today we will cover the basics.

Multiplying Numbers in monday.com

For example, you may want to calculate the total cost of two columns: Let’s say you are a freelancer, and you charge your clients hourly. You want to know the total bill to a client at a fixed hourly rate. Here you would need 2 number columns. The first would be your hourly rate, and the second would be to fill in the amount of billable hours for that month.

To multiply two numbers, create a “Formula” column. Clicking on the three dots beside the column will allow you to set up the formula, and then you will see a dropdown menu with three options: 

  1. Columns
  2. Functions
  3. Constants

Select the columns you want to multiply from the “Columns” menu. Put a multiplication sign (*) between them.

For instance, to multiply “Current Billable Hours” and “Hourly Rate,” the formula would be:

{Current Billable Hours} * {Hourly Rate}

Click “Save,” and the multiplied amount will appear in the new column.

Adding Numbers in monday.com

Sometimes, you may want to add two columns, like Client X and Y revenues.

To add the numbers, create a new “Formula” column. Select “SUM” from the “Functions” menu. Add your desired columns with a comma between them inside the SUM parentheses.

For example, to add 30 and 70, the formula would be:

SUM({Client X Revenue}, {Client Y Revenue})

Click “Save,” and the total amount will appear in the formula column. 

You can add as many columns as you like within the formula. Just separate them with commas.

Adding or multiplying numbers in a “Formula” column on monday.com is straightforward. You can set it up with just a few clicks and start calculating your data. It’s an excellent feature for anyone who needs to keep track of metrics and wants to see them all in one place. 

Still need more help? Why not get a 30-minute free consultation? Our team is ready to make your monday.com journey as smooth as possible. 

Read More

2 FREE consulting hours when you sign up for monday.com

Email us once you have signed up to arrange for the consulting time.

2 Hours FREE

Get 2 hours of free customized implementation & consulting when you sign up for a monday.com account below

Please email us upon sign up to claim your free hours.