Help w/COUNTIFS and multiple NOT(CONTAINS) functions

Options
jmo
jmo ✭✭✭✭✭✭
edited 07/29/20 in Formulas and Functions

Hi team - I created a formula to count the number of numbers of errors in a specific month and does NOT CONTAIN "general counsel" in the Division Requested By column, the June example works:

June example formula:

=COUNTIFS([Main row]:[Main row], 1, Created:Created, IFERROR(MONTH(@cell), 0) = 6, [Incorrect format]:[Incorrect format], 1, [Division requested by]:[Division requested by], NOT(CONTAINS("general counsel", @cell)))

I now need to add another NOT(CONTAINS) formula to not count "Low" items in the IRR column but I can't seem to get the formula right. I'm using:

=COUNTIFS([Main row]:[Main row], 1, Created:Created, IFERROR(MONTH(@cell), 0) = 7, [Incorrect format]:[Incorrect format], 1, [Division requested by]:[Division requested by], NOT(CONTAINS("general counsel", @cell), IRR:IRR, NOT(CONTAINS("low", @cell))))


What am I missing?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!