If you are trying to track simple expenses or even calculate the total number of hours spent on a project, you can use the Numbers column! the numbers column allows you to get simple calculations of the sum, average, median, minimum, maximum, or a count of all the numbers in the list.
Using the Numbers Column
- Step 1
Click on the little sign on the right side of your board and choose "Numbers" to add a Numbers column to your board.
- Step 2
Next, enter numbers into some pulses (rows) in your column.
Note ✍️: You can enter negative values as well!
- Step 3
Once you have entered content into the column, you can click on the box located at the bottom of the group in the column. This will open a dialogue box, which will allow you to change the Unit (none, dollars, pounds, euros, or percentage) and the Function (None, sum, average, median, min, max, count) of the column.
Tip 💡: You can type in your own unit by clicking "Type your own." For example, you could type in "hours" and then all values entered into the column will be followed by the unit "hours."
Note ✍️: Calculations are made per group. The results will show in the box at the bottom of each group in the Numbers column. In the example shown below, the total is calculated for the group called "Week 1," while a separate total is calculated for the group called "Week 2."
If you would like to see the calculation applied to all values in all groups, simply click on the box where you would change the Unit and Function, and you will see the overall calculation for the board at the bottom:
Note ✍️: If you filter the board by a keyword, such as a person, the calculation at the bottom of each group in the Numbers column will update with the new value for those filtered results. For example, if I search only for tasks assigned to myself, I can see the new total amount that is assigned to me. Check out this example shown below for the total number of hours I have assigned to me in a week:
Head over here to see how you can manage a budget on monday.com using the numbers column! If you are looking for more complex calculations, such as multiplication, division, etc., check out the possibilities of our Formula column here:)
If you have any questions, please feel free to reach out to us at firstname.lastname@example.org! We have an awesome Customer Success Team waiting to help!