counting tasks in a project

Hi i have a sheet that i am counting the number of tasks that each resource has, it works fine if only one resource is on a task but if i have multiple resources it doesn't count that task, i am using the formula =COUNTIFS({Project Schedule- Assigned To}, $[Primary Column]@row, {Project Plan- Status}, [Column2]$9), any suggestions?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!