#Invalid Data Type - multi drop down

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

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!