We would like to create a list of all team members and the sum of their days on task for each team member, but we are having issue when there are multiple people assigned to one task.
Each name should be only once in the list with the sum of the days.
The result when summing up the table of our screenshot should be
Rahul 7
Birgit 2
Alex 3 (or 6 if not divided )
Markus 3 (or 6 if not divided)
*We have tried the fuzzy match formula : SUMIF( [ Assigned to], " *Alex Ziehler*" , [ Required days on task] ) but it does not work with multiple assigned to. However, it works in excel.
Is there any better way to get this done in smartsheet?
