CountIfs X does not contain...


I am trying to get a formula to function and am having trouble.

=COUNTIFS({KBeaver Workload Range 1}, "Complete", {KBeaver Workload Range 3}, "1", {KBeaver Workload Range 4}, NOT(CONTAINS("E:", @cell)), {KBeaver Workload Range 4}, NOT(CONTAINS("M:", @cell)))

This is attempting to count tasks completed in Q1 by looking for the "Complete" status, then looking for a "1" in quarter, then filtering out non-tasks (does not contain "E:" and does not contain "M:").

However, the formula above only gets me "Incorrect Argument Set".


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!