SUMIF funtion in MONDAY.COM?


I have a problem that I hope someone here can assist me with,

My board has 1000 items. The items come with a number column (named “Volume”). Of the 1.000 items may appears multiply times (Identical Item) with different “Volumes”. I want to sum the “Volumes” from identical items. (I excel called SUMIF). How can I do that? - any work arounds?

Ideas are highly appreciated,

Hello @Solplanet,

You can use the Duplicates and Uniques merge functionality for this. Even better you can create a template that will automatically run based on a particular trigger (for example, when a status changes).
Basically, in the merge settings, for the “Volume” column, choose “Custom”, then “Calculate” and the “Sum”.

Here is a demo of the merge functionality in action.

If you have any questions about the app, you can always reach out