I am doing a metrics sheet to give department heads better visibility on our workflow. One of the metrics I need is how many items have been shipped, but not yet invoiced, I have a date shipped culumn (date) and an invoiced check box (boolean). Several other formulas have similar setup criteria and are also not working. the formula I have right now is
=COUNTIFS({Open Order Report Range 4}, =ISDATE(true), {Open Order Report Range 5}, =ISBOOLEAN(false))
but it returns 0, when I look at the data there are many orders that should meet the criteria.
Another metric is for sales reps to know how many of their items have been shipped
=COUNTIFS({Open Order Report Range 6}, =Metric11, {Open Order Report Range 4}, =ISDATE(false))
Metric11 is SR name.
also returns 0 when it should have counted items.