• Time to read 1 minute
formula column

Are you missing the Excel formula and mathematic capabilities? Do not worry because monday.com has a formula column!

The benefit of monday.com's formulas is that you can make calculations across columns. It goes from a simple mathematic equation to more complex functions and formulas. A great thing about the formula feature is that it has no limitations. You can work out return on investment, sales, budgeting, averages, and much more!

Please Note: The formula column is only available for the Pro and Enterprise plan. If you were on a Pro plan and downgraded your account, the formula columns you already have in place will remain intact, but you will not be able to create any further formula columns.

How to add a formula column

To add it, click on the + icon located on the top right of your board and select "column center". Once in the center, select the option "Formula" as in the screenshot below:

formula 1

Once your column is added, click inside the column to add your formula. 

minus

Adding units to a formula

This is easy to do! If you want your unit in pounds to show after your formula, input your formula and then add & "£." If you want to add pounds before your formula start with "£" & and then add your formula.

Formating a formula

Again, another easy thing to do that is vital when calculating sums. You can format your result exactly the way you want it to look like by using the formula TEXT. Let's take an easy example: I want to multiply 10 by 1250 and I want my number to show the following way: $12,500.00.

Formula: TEXT(MULTIPLY({Deals},{Amount}),"$#,##.00)

2

 

Each # represents a number. I have added .00 by the end because I want my formula to end by.00 but you can replace this by .## if you want your number to end with proper numbers. 

Adding a sum at the bottom of a formula

Similarly to the numbers column, you can see the overall calculation for each group. By clicking on the sum box you can change the unit and function as displayed below.

sums

Please Note: The total only takes into account numeric values. If your column has both numeric and text values, we will only count the numeric values. Mixed values like Lea123 will not be taken into account in the total. If all values are non-numeric, you will get N/A at the bottom as in the screenshot below. 

Watch the formula column video to find out more - click here!

Example 1 

In this example, you can calculate the total amount of commission made per employee per month in £.

Formula: ({Deals}*({%Commission}/100))

comission

Example 2

In this example, we want to calculate the average of the grades for the last 4 weeks

Formula: AVERAGE({Week 1},{Week 2},{Week 3},{Week 4})

colour

If you have any further questions about the formula column please don't hesitate to reach out to our monday.com specialists at sales@enable.services

Want to know more about monday.com?

Click here!