COUNT(DISTICT(COLLECT formula for multiple sets of criteria

Brett Hughes

I am trying to use the COUNT(DISTICT(COLLECT formula count the amount of unique Request ID's that are On-Time/Late and are assigned to "Brett". I keep getting a value of 1 for some reason when looking at my On-Time column, but get the correct values when looking at my Late column.

In the images below you can see I am suppose to have 2 "Late Requests" and 3 "On-Time Requests".

On my Dashboard sheet, Late Requests has the correct amount, and On-Time Requests is pulling 1.

Formulas are as follows:

On-Time: =COUNT(DISTINCT(COLLECT({(Duplicate)Completion Date Updates Range 1}, {(Duplicate)Completion Date Updates Range 4} <= 0, {(Duplicate)Completion Date Updates Range 3}, "Brett")))

Late: =COUNT(DISTINCT(COLLECT({(Duplicate)Completion Date Updates Range 1}, {(Duplicate)Completion Date Updates Range 2}, >0, {(Duplicate)Completion Date Updates Range 3}, "Brett")))

Please note:

(Duplicate)Completion Date Updates Range 1 = Request ID

(Duplicate)Completion Date Updates Range 2 = Late

(Duplicate)Completion Date Updates Range 3 = Assigned Team

(Duplicate)Completion Date Updates Range 4 = On-Time

Paul Newcome

You are missing a comma between the second range and criteria set in the On Time formula.

Paul Newcome

You are missing a comma between the second range and criteria set in the On Time formula.