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")
Best 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."
Answers
-
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."
-
That WORKS!! You are a genius, my friend...THANK YOU!
-
Glad I could help!
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!