Sumif with multiple assined to

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?





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!