using COUNTIFS with contains

Hello,

I'm trying to count the number of rows where deployment complete or cancelled is not checked, where Deployment Type is "New Deployment" and Deployment Tier is either "Plus" or "Plus Unlimited." The formula I'm using is getting an Invalid Operation error.

=COUNTIFS({Deployment Complete}, "0", {Deployment Queue Project Cancelled}, "0", {Deployment Type}, "New Deployment", {Deployment Tier}, CONTAINS("Plus"))


Thanks for your help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!