COUNTIFS with multiple criteria



I am a newer Smartsheet user and am learning as I go. I have tried several times to use COUNTIFS functions to count specific criteria from 2 columns in my source sheet, but continue to get the UNPARSEABLE error. (I also tried COUNTIF, then CONTAINS, but could not get that to work either.

We are wanting to count how many "General Applicants" in the Provider Type column also have "Founded" in the Disposition column.

This is the most recent formula I have tried with no luck: =COUNTIFS({8.31.22_Data_ProjectRollup Range 2}, "General Applicant"), COUNTIFS({8.31.22_Data_ProjectRollup Range 3}, "Founded")

Thanks for any help/suggestions you can give me!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!