Hi,
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 support@kolaai.com
