sum hours of an assigned to, in a multi contact column

Angela.R

=SUMIF([Assigned To]:[Assigned To], =[Assigned To]@row, [Hours Testing]:[Hours Testing])

Works great, if the "assigned to" is only a single person.

When there is more than one contact in the cell, it is unable to find.

I'd like to not have a name spelled out in the formula eg "Jane" I'd rather it look to =[Assigned To]@row. that way if the user in that cell changes, it will automatically update the new total hours.

If Jane and Kara are listed in the "assigned to" my formula above doesn't included.. Only when it is a single contact. appreciate the help and what updated formula i should be using.

Kelly Moore

Hey @Angela.R

Try this

=SUMIF([Assigned To]:[Assigned To], HAS(@cell, [Assigned To]@row), [Hours Testing]:[Hours Testing])

Smartsheet has provided a few functions that specifically help with multi-select columns. For more info on those functions, look here

cheers

Kelly

Kelly Moore

Hey @Angela.R

Try this

=SUMIF([Assigned To]:[Assigned To], HAS(@cell, [Assigned To]@row), [Hours Testing]:[Hours Testing])

Smartsheet has provided a few functions that specifically help with multi-select columns. For more info on those functions, look here

cheers

Kelly