Why can’t you do it when you save the record ?
Just added this as a formula.
5 Likes
The problem is that I do not need the sum for whole record. It is actually the value from input. But I need the sum per week. So the first step is to search for days in this week and than I can work with them. I do not know how to make it when i save the record.
Thank you a lot Emmanuel. It seems to be exactly what I need.
That does make it a awful lot easier 
1 Like
I need help with lists. I have list of items and every item has parametr which is a list. I need to count this list parametrs for every item but when I use “count” it always counts everything in list and result is one number.
EG:
list:item1’s parametr (contains values 1,2,3) => count = 3
list:item2’s parametr (contains values 1,2,3,4) => count = 4
list:item3’s parametr (contains values 1,2,3,4,5) => count = 5
when I use count I always get result 12 (as one number) BUT I need list with 3 values for each item (3,4,5)
Is there any way how to do it?
Any recommendation what to try?
Hello,
Feedback back to the sumproduct formula @emmanuel.
Right now, we must be sure the two list coincide well (= risk). A function on a list would have avoided this. So we could have something like :
LIST OF THINGS : SUMPRODUCT.
- List 1 : This thing’s Number 1
- List 2 : This thing’s thing’ Number 2