Hi,
I’m a long-time lurker and the answers in this forum helped me a number of times. However, I’m struggling finding a solution to the following problem:
Essentially I’m trying to extract a sum of points from one table and embed it in another table. Sounds simple, but please see details below:
There are 4 tables:
A, B, C and D
Each table has a list of records grouped by sprints with a point value allocated to each record.
I created a separate table E which is supposed to show the following:
- Group data by sprints
- For each sprint, have the allocated points for each table
| Sprint 1: |
| Table | Allocated points|
| A | 150 |
| B | 102 |
| C | 25 |
Ideally, I’d have a formula that would show the following:
If {Table Name} = X THEN show sum of points for the sprint.
Ideally that would work for all tables by looking up the table name A B C and D.
Please let me know if there’s a way to do this or are there too many relationships here that are difficult to untangle?
Thanks,
Pepe
