Hello!
I've created a sheet to pull metrics from for some charts I need to make and I'm trying to create a formula that counts the number of projects that are assigned to each employee and its progress level.
I more or less understand the first part of the formula counting the assigned projects, but I'm stuck on how to get it to limit the criteria based on information in my primary sheet.
=COUNTIFS({Contact Column}, FIND("address@address.com", @cell) >= 0)
The fields I need it to use to limit the counts are all check-boxes.
Let me know if you need anymore information.
Thanks!