#Invalid Data Type - multi drop down

Owen Smith

I have a cross sheet formula and data is counting with the exception of value 1. The Intake Sheet Range 1 with "Formal Quote" has multi select dropdown.

=COUNTIFS({Intake Number of touches}, Days@row, {Lead-Time exempt}, =0, {Intake Sheet Range 1}, ="Formal Quote", {Intake Sheet Range 2}, IFERROR(MONTH(@cell) = 4, 0))

Paul Newcome

To incorporate the HAS function, you would do like this...

=COUNTIFS({Intake Number of touches}, Days@row, {Lead-Time exempt}, =0, {Intake Sheet Range 1}, HAS(@cell, "Formal Quote"), {Intake Sheet Range 2}, IFERROR(MONTH(@cell), 0) = 4)

Owen Smith

That works perfectly. Thank you.

Paul Newcome

Lets try correcting a little syntax issue first and see if that helps.

=COUNTIFS({Intake Number of touches}, Days@row, {Lead-Time exempt}, =0, {Intake Sheet Range 1}, ="Formal Quote", {Intake Sheet Range 2}, IFERROR(MONTH(@cell), 0) = 4)

Owen Smith

Thank you Paul. The syntax fix has data calculating now. It looks like my multi drop down has multiple selections on some instances which leaves those off the count if. I tried the IF(HAS{Intake Sheet Range 1}, "Formal Quote"). That doesn't seem to work.

Paul Newcome

To incorporate the HAS function, you would do like this...

=COUNTIFS({Intake Number of touches}, Days@row, {Lead-Time exempt}, =0, {Intake Sheet Range 1}, HAS(@cell, "Formal Quote"), {Intake Sheet Range 2}, IFERROR(MONTH(@cell), 0) = 4)

Owen Smith

That works perfectly. Thank you.

Paul Newcome

Happy to help. 👍️