Trying to get a count of status for specific team members

I am trying to find out how many initiatives with a specific status have certain team members in the Project Team column. For example, how many initiatives is Leo on the team where the status is Not Started? I have tried the following:

=COUNTIFS({EITPort_Status_24}, "Not Started", FIND("Leo Liao", @cell, >0)) - Gives me an Invalid Operation error

=COUNTIFS({EITPort_Status_24}, "Not Started", HAS(@cell, "Leo Liao")) - Gives me an Incorrect Argument error

Any thoughts on how to make this work?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!