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
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!