Using Contact List as matching criteria for SumIF Formula
Dear Smartsheet Community ... I am stumped and exhausted my research efforts.
We are not ready to implement resource management, users are not bought in but we do have to find a way to understand the teams balance. These individuals work on projects and have daily activities to tend to. The goal is to first understand the volume of project work currently open by Assignee. We have provided each project with a score value (1 through 3). This value is found on the project plan at the task level. It is populate when the task becomes active. I am now trying to count the number of open task and the sum of the score for open task by assignee. I have created a new spreadsheet to start capturing this detail.
I am looking for the correct formula that will execute a SUMIF.
Range for the range for the criteria is located on the project plan (another sheet) and is the Assignee Column, Criteria is a column on the sheet where I need the results of the formula and is also a contact list. Where these two values match, I want a sum of the Score from the reference sheet.
I have explored using the Find functionality but I am not getting anything to work. Any advice or assistance is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!