Hello! I need help with a formula, experience with Countifs OR AND formula?

Paola Preciado
edited 07/05/22 in Formulas and Functions

I am not sure if I am doing this right, I need to count "reference another sheet" if status is closed, completed OR sent to contractor (any of them), AND program is "APD".

Here is my formula:

=COUNTIFS(OR({Classification Review Status}, "Completed", {Classification Review Status} = "Closed", {Classification Review Status} = "Sent to contractor"), AND({Classification Review Program}, "APD"))

It says Invalid Data Type, I am not sure if I can use this formula when reference to another sheet


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!