Hello! I need help with a formula, experience with Countifs OR AND formula?
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
Answers
-
Hey @Paola Preciado
Try this
=COUNTIFS({Classification Review Status},OR(@cell= "Completed", @cell= "Closed", @cell= "Sent to contractor"), {Classification Review Program}, "APD")
Will that work for you?
Kelly
-
That worked! Thank you So much Kelly!
Paola
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!