Incorrect Argument Set with nested IF

Counting number of occurances where month/year is 1/23 AND where cell within the row does not contain "Color Add"

=COUNTIFS({New Product Status (Imagen) Go Live Launch Date}, IFERROR(MONTH(@cell), 0) = 5, {New Product Status (Imagen) Go Live Launch Date}, IFERROR(YEAR(@cell), 0) = 2023, {New Product Status (Imagen) new or color add}, NOT(CONTAINS("Color Add", @cell)))

above results in Incorrect Argument set - any idea what I'm doing wrong?

ALSO why this is frustrating is that I have same formula pointing to two similar sheets - one works and the other does not:

This formula pointing to my "Archive" sheet works:

=COUNTIFS({ARCHIVE Launched New Products (Imagen) Go Live Lau}, IFERROR(MONTH(@cell), 0) = 5, {ARCHIVE Launched New Products (Imagen) Go Live Lau}, IFERROR(YEAR(@cell), 0) = 2023,{ARCHIVE Launched New Products (Imagen) new or colo}, <>"Color Add")

But this formula pointing to my "Main" sheet DOES NOT work:

=COUNTIFS({New Product Status (Imagen) Go Live Launch Date}, IFERROR(MONTH(@cell), 0) = 5,{New Product Status (Imagen) Go Live Launch Date}, IFERROR(YEAR(@cell), 0) = 2023, {New Product Status (Imagen) new or color add}, <>"Color Add")

Find more posts tagged with

Accepted answers

Kleerfyre

The @cell part at the end is wrong. It will need to be @cell = "Color Add", but in doing that, you will need to adjust your NOT(CONTAINS part. Try replacing it with NOT(@cell = "Color Add")

All comments

Kleerfyre

The @cell part at the end is wrong. It will need to be @cell = "Color Add", but in doing that, you will need to adjust your NOT(CONTAINS part. Try replacing it with NOT(@cell = "Color Add")

Stephanie Kiecker

That WORKS!! You are a genius, my friend...THANK YOU!

Kleerfyre

https://community.smartsheet.com/discussion/comment/381391#Comment_381391

Glad I could help!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.