I’m trying to create a column that will calculate the average of all the numbers in the column next to it.
For example, in the below screen shot (ignore all the exclamation points), instead of the average column only looking at the subitem that it’s on, it will calculate the average of 92, 67, and 41 and pop the result in each of the subitems in the Average column.
Is this possible?
For context, I’m trying to calculate the average duration for each subitem where each subitem will have a different start and end date. Maybe there’s an easier way to do this?
Unfortunately, it is not possible to calculate a cumulative average directly within Monday.com, as the platform does not support retrieving data from previous rows.
If you need to compute an average, you may need to use a third-party automation tool.
You can put the average of a subitem number column into the parent item. Either with the monday function “Show summary in Parent” and modify the parent column to show average or by using the app Rollup Subitems.
