Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
COUNTIFS Help - what is wrong with my formula
Can anyone tell me what is wrong with this?
I am trying to count all the cells in column "Monday" that does not contain the word hold (case doesn't matter but I haven't gotten that far) where the cell in the same row in the column Description contains LIRR.
I get the error "Incorrect Argument Set"
=COUNTIFS([Monday]3:[Monday]86, NOT(CONTAINS(("Hold")), Description3:Description86, CONTAINS("LIRR")))