counting tasks in a project

ShaunW

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?

Amit Wadhwani

Hi @ShaunW

You can use the HAS function for multiple contacts in cell. You an try the below formula

=COUNTIFS({Project Schedule- Assigned To}, HAS(@cell, $[Primary Column]@row), {Project Plan- Status}, [Column2]$9)

Best Regards

Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/

If my solution helped you, do not forget to mark it awesome

ShaunW

many thanks that didn't quite work, if i add that statement into the string it just returns a zero