What is the formula that I will need to track how many completed projects an employee has worked on

Here it the formula I was trying but I kept getting an #INVALID REF.

=COUNTIFS({DCIM Projects 2020-2021 Range 1}, ="Complete", AND({DCIM Projects 2020-2021 Range 2,="Susan ****"})) (Replaced employees last name with * for privacy)

We have a few projects that take multiple employees and some that it is individual. I am hoping that the formula will pull the information every time the employee is listed whether it is in a group or individual.

Any help you can offer would be appreciated

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!