Invalid Operation with Countifs formula

Anne-Solene Monrouzeau
Anne-Solene Monrouzeau ✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

Hi,

The formula =COUNTIFS({CR Requests Inventory Request Monday}, [Monday of the week]@row, {CR Requests Inventory Status}, NOT("5) On Hold")) returns an Invalid Operation error. I checked the column properties and the references, all look good.

The same formula works referencing another sheet.

=COUNTIFS({CR Archived Requests Archive Monday}, [Monday of the week]@row, {CR Archived Requests Request Status}, NOT("5) On Hold"))


Any idea how to troubleshoot this?

Tags:

Answers