#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
-
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)
-
That works perfectly. Thank you.
Answers
-
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)
-
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.
-
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)
-
That works perfectly. Thank you.
-
Happy to help. 👍️
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!