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.

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.