anyone knows the way to calculate a number column vertically?
It’s able to calculate among different columns by using formula column, but to do that with a same column and different items is impossible as I know.
Any updates on this?
Monday.com is not a spreadsheet. Look at dashboards to aggregate data from many items.
That is both true and not. It is not, to the best of my knowledge, possible to for example visualize in a dashboard what percentage of a columns items has a value over 50 in it?
It is unfortunate formulas aren’t usable in dashboards. One trick could be something that will calculate a formula on the item to a number column, and those over 50, set to 100, and those under 50 set to 0. Then the simple average of those 100s and 0s will be the percentage of those over 50.
Hello Sosuke,
The easiest way is to automatically feed your bord into a spreadsheet and make calculations there. Our Smart Spreadsheet app allows to do so by adding spreadsheet as a board view.
Hi Sosuke,
Natively it is not possible, but it is easy to do with the Advanced Formula Booster, the 3rd-party app that takes formula to another level.
Among many unique features, the app offers the ability to read/update columns from all the items in a group or in a board. So you could sum up a number column vertically for the current group.
The syntax is super simple:
In the above syntax, the result of the sum is not cast to a column, but rather stored in a variable. You could cast it to the column of your choice or you could use the SUM in a calculation
As an example, if you wanted to calculate the % of the number relative to the average of the group, you could create a calculation like this:
to give you something like this:
SUM is only one of the many functions you could apply to the column. In a nutshell, with the Advanced Formula Booster, you can do anything you want.