Issue using COUNTIF function with OR condition where OR is reference to different sheet


I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but when I use different sheet reference I get “#Invalid Operation” error.

Formula that I am using is

=COUNTIFS({Primary_Owner}, PC@row, {Priority}, "Medium", {Status}, OR("WIP", "Open"))

I am trying to look for a formula, that counts number of issues that are assigned to a Primary Owner where the priority is “Medium” and Status is either WIP or Open.

Can anyone help on how to achieve this using countifs with OR condition, or is there any other formula which I can use to achieve this results?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!