Assistance Needed (#INVALID DATE TYPE)
I have a sheet with multiple rows and columns. Two of the columns are for Recruitment Stage and Recruitment Priority. Recruitment Stage has (7) dropdown values, and Recruitment Priority has (6) dropdown values. I'm attempting to use a COUNTIFS statement to produce a total count of partners who are either in the 3-Introduction or 4-Engaged (Recruitment Stage), and are labeled as Priority (Recruitment Priority). I created the following formula, but receive a response of #INVALID DATE TYPE. What am I doing wrong?
=COUNTIFS({Alteryx Recruitment & Onboarding Tracker Range 1}, ="3-Introduction") = OR({Alteryx Recruitment & Onboarding Tracker Range 1}, ="4-Engaged") = AND({Alteryx Recruitment & Onboarding Tracker Range 2}, ="Priority")
Best Answer
-
See below:
=COUNTIFS({Alteryx Recruitment & Onboarding Tracker Range 1}, OR(@cell="3-Introduction", @cell="4-Engaged"), {Alteryx Recruitment & Onboarding Tracker Range 2}, @cell="Priority")
Answers
-
See below:
=COUNTIFS({Alteryx Recruitment & Onboarding Tracker Range 1}, OR(@cell="3-Introduction", @cell="4-Engaged"), {Alteryx Recruitment & Onboarding Tracker Range 2}, @cell="Priority")
-
@Leibel Shuchat, thank you so much for the assistance! I truly appreciate it! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!