Incorrect Argument Set with nested IF

Stephanie Kiecker
Stephanie Kiecker ✭✭✭✭
edited 06/20/23 in Formulas and Functions

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")

· Share on FacebookShare on Twitter

Best Answer

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Answer ✓

    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")

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!