Formula countifs and is blank

Options

I am trying to count the number of rows that contain the purpose of "appointment help" only not how many cells contain "appointment help". Trying to determine how many calls received were the result of needing help scheduling an appointment only.

I currently have 311, using, =COUNTIF([Purpose 1]:[Purpose 5], CONTAINS("Appointment", @cell)) and have tried the following but continue to get an error:

=COUNTIFS([Purpose 1]:[Purpose 1], HAS("appointment help", @cell), AND(ISBLANK([Purpose 2]:[Purpose 5], @cell)))

=COUNTIFS([Purpose 1]:[Purpose 1], CONTAINS("appointment help", @cell), AND(ISBLANK([Purpose 2]:[Purpose 5], @cell)))

=COUNTIFS([Purpose 1]:[Purpose 1], HAS("Appointment Help", @cell), [Purpose 2]:[Purpose 5], AND(ISBLANK("", @cell)))

=COUNTIFS([Purpose 1]:[Purpose 1], CONTAINS("Appointment Help", @cell), [Purpose 2]:[Purpose 5], AND(ISBLANK("", @cell)))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!