Countifs formula help needed

Options
Lee Ratzlaff
Lee Ratzlaff ✭✭
edited 11/07/22 in Smartsheet Basics

Hello!

I need a way to count the total number of records associated with a specific person, in a grid separate from where the data is stored and can't quite figure it out.

Each record has an Assigned Staff column, it is a contact list. Each individual submits data for each client once a month, each record has a reporting period date column. They can have as few as one client or as many as ten clients. I need to count how many records each staff submitted for the previous month. I have made a grid that includes a cell link to populate the email addresses of all employed staff.

What syntax would I need for it to create a metric that displays the total caseload for each staff on a monthly basis?

Here's an example of a different formula that counts all records from last month who were actively enrolled and involved with PS =COUNTIFS({ND CYFD}, "Protective Services", {ND Enrollment Status}, "Active", {ND Reporting Period}, MONTH(@cell) = (MONTH(TODAY()) - 1))

I just need to figure out how to write the syntax so it references the cell with the staff email address instead of being involved with PS.

Thanks!

Best Answer

Answers