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
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!