What formulas should I use to count two criteria (including from a multiple dropdown option)?
I want to count "Enrolled" from "Case Status" AND "Medicaid" from "Insurance Type." I used the COUNTIF formula, but it seems like Smartsheet isn't counting the Medicaid cell if it's within a cell with multiple criterias selected. Screenshots below:
You can see that even though 2 fit the criteria, the sheet summary only accounts for 1 as the response.
I tried the below formula:
=COUNTM(COUNTIFS([Case Status]:[Case Status], CONTAINS("Enrolled", @cell), [Insurance Type]:[Insurance Type], CONTAINS("Medicaid", @cell)))
Help Article Resources
Check out the Formula Handbook template!