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

=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.

Tags:

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    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

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!