Sumif with multiple assined to

hsin-ting.tsai91231

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?

 

Andrée Starå

Hi,

I think I have a solution!

Can you maybe share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Hi,

Did you manage to get something set up?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting