this is my first post, sorry if it is a bit dumb. I tried to find if a similar question was posted, but couldn’t find any… so, here it goes.
I have a table representing tasks. A task have a sprint reference (“text”), can be assigned to someone (lookup from the “people” table), and finally can have an estimated effort in days (positive number). eg.
Task 1 / Sprint alpha / Laurent / 2
Task 2 / Sprint alpha / Laurent / 3
Task 3 / Sprint alpha / Nick / 0.5
Task 4 / Sprint alpha 2 / Laurent / 1
Task 5 / Sprint alpha 2 / Chris / 5
Task 6 / Sprint alpha 2 / Chris / 3
Task 7 / Sprint beta / Chris / 2
I’d like to display the sum of each people’s estimated effort on each sprint. eg.
Sprint alpha / Laurent / 5
Sprint alpha / Nick / 0.5
Sprint alpha 2 / Laurent / 1
Sprint alpha 2 / Chris / 8
Sprint beta / Chris / 2
I successfully computed the sum: I added a new column, and now I have the sum for each row, but my issue is that now I have multiple rows that are identical except for the task name (that I don’t need anymore).
Sprint alpha / Laurent / 5 (hidden columns = Task 1 / effort 2)
Sprint alpha / Laurent / 5 (hidden columns = Task 2 / effort 3)
Here I want to have only one of them. That seems like a nightmare, or I’m simply missing something … how do you filter out “doublons” within a table (going from 7 rows down to 5 in my example)? Instead of a view, should I use a second table that would be “populated” from my task table? But I have no clue how to do that
edit: found out about formulamap + addrow. Thats seems a bit like overkill, and will force users to click on a button instead of having an always up-to-date view. Would that be the only way to achieve my goals?
Help on that matter would be much appreciated!