I am using SharePoint online. My final goal is to show a calculated value.
So what I am trying is: SUM all values in one column if the ID of the item is the same. It is a list of documentations and informations about how long it took to create it.
There are several 100 documentations for one Item. The information about how long it took to create it is always different. How can I show the summed up time for every item?
It is only possible to show the summed up time behind every single item right?
Would it be possible to use a SUMIF function with conditions from other lists?
Here you see my List1. Items can show up several time. There is a calulated time for every item. Now I want to sum all time values if the item ID is the same. But I don't want them to be summed up in List1 but List2.
Here is my List2, where I have an overview of the items I have. Here I would like to show the summed up times from List1 by item.
Thanks for your help.