I have a dashboard roll-up sheet that is using a COUNTIF
=COUNTIFS({sheetname}, [Column2]10)
formula to count the number of cases an employee has. I know the employee has cases on the sheet, but the field shows zero, instead of the number of cases that are assigned to them.