Bugs: SUMIFS does not find multiple users
Comments

I use the [Assigned To] column along with an Index formula to find the correct charge rate for a resource and then use a multiplier to calculate Cost to Complete for a task (which rolls up to the the project).
The formula uses the contact in the [Assigned To] column, and index lookup for the cost rate multiplier, the [% Complete], [% Allocation] and the [Duration] in order to calculate the Cost to Complete for the project. This rolls up and informs all of our project dashboards.
I was looking forward to the multiple Assign To capability, but I can't use it. Even if I assume that each resource is equally Allocated, I can't look up the rates for individuals, or even automatically count how many resources are in the box and then estimate using a 'blended rate'.
Any ideas anyone?

Has this been fixed? I am trying to write a formula to count the number of assignments a contact has where the assignment column is a multiselect contact column.

Daniel,
I am using a formula similar to the one you provide above
Row 10: =SUMIF([Assigned To]:[Assigned To], FIND("Emily Young", @cell) > 0, Hours:Hours)
This formula works, however if I try to use it in the row below for a different name
Row 11: =SUMIF([Assigned To]:[Assigned To], FIND("Timothy Lawrence", @cell) > 0, Hours:Hours)
Then Row 10 shows #CIRCULAR and Row 11 shows #BLOCKED and I'm not sure why. I need a total amount of hours for each employee on a project.

Was tlawrence17's question on 9/20/19 ever answered? I'm running into the same problem.

@tlawrence17 and @DeeL
Are you putting the formula in one of the referenced columns?
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives