I have two tables (on different pages)
The first auto-creates a row each day, and looks like:
Table_#1
| Name | Created date | integer A |
| 1/1/2001| 1/1/2001 | 5 |
The second table is also autogenerated, and looks similar to the following (although with two autogenerated rows per day
Table_#2
| Name | Created date | integer B |
| type_1 | 1/1/2001 | 7 |
| type_2 | 1/1/2001 | 8 |
I want the a way to get the following:
Table_#1
| Name | Created date | integer A | value C |
| 1/1/2001| 1/1/2001 | 5 | (7+8)/2 |
A new row on Table#1 with the average of the values of B with the same creation time as the row on Table#2
Any ideas how to do so? I didn't manage using rollups and etc (and tried bing chat as well, just to make sure)
(In reality the first table is a habit tracker, and the second table is exercise with weights, reps and completion rate for each)
