How to attribute work completed to an employee
I am trying to find the correct data type and formula to connect complete work (that is reported via form) to the employee who completed the work - in the sheet summary.
I'm looking for daily completion per employee, as well as options for weekly, monthly, and all historical in a data roll up. Once I get the formula the findings will then be displayed on a dashboard for progress reports.
I have tried using a contact list, dropdown list, and text/number fields to gather the employee's name. Then tried CountIF and CountIFS formulas to calculate and it doesn't seem to be working. The work completed data is coming from a dropdown list with radio buttons "Attempted" vs. "Completed"
I just get #Incorrect Argument Set for the formulas below
Example 1: Contacts with CountIF: =COUNTIFS([Outcome1]:[Outcome20], "Completed", [Navigator Name]:[Navigator Name], "Name")
Example 2: Text/number with CountIF: =COUNTIF([Navigator Name]:[Navigator Name], "Name", [Outcome1]:[Outcome20], "Completed")
If I use the Count formula it doesn't seem to recognizes the employees name and counts the number of submissions by that one employee...
CountM formula does recognize the number of submissions by the entire team but isn't helpful.
Any guidance is welcome...
Help Article Resources
Check out the Formula Handbook template!