COUNTSIFS does not Contain

RingJake ✭✭✭✭✭
edited 11/05/21 in Formulas and Functions


I've put together the following formula, to count certain items in a different sheet that don't meet certain criteria, please see below.

=COUNTIFS({SE-Region}, Region@row, {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, <>CONTAINS("Onboarding", {Summary}))

The formula works until the "{Summary} ("Onboarding", {Summary})), so I'm not sure why this isn't taking.

The answer is outputting "0" to me and the formula is not taking, which I know is not true. Is there anything wrong with my syntax?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!