Contains If Returning Incorrect Argument Set



I created this formula:

=COUNTIFS(CONTAINS("2009", {Protocol #}), {Amendment}, "0")

To review a list of Protocol Numbers (column) that contain 2009 (the year, part of the protocol number) and are not amendments (column of check boxes, want those that are unchecked).

I tried a variety of versions of this, but this error message "Incorrect Argument Set" seems to be the best error message (ha!) so I am posting this version for suggestions.

Ideas? Thanks in advance.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!