COUNTIF with NOT - Invalid Operation


I'm trying to do a NOT with a COUNTIF referencing another sheet and keep getting INVALID OPERATION and pretty stumped as Ive tried numerous ways according to documentation.

Any ideas?

Many Thanks.

Best Answer

  • David Tutwiler
    David Tutwiler Overachievers Alumni
    Answer ✓

    I think it's having problems with you passing in the range again. I think this will get you there.

    =COUNTIFS({Assigned To}, Name@row, {Issue Type}, "Bug", {Status}, NOT(@cell = "Complete"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!