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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!