Countif and Contains formula


I am needing a formal that counts items that are the following:

Range 1 = Consultation

Range 2 = Completed

Range 3 CONTAINS Ute Mountain Ute Tribe

The below is what I have, but it says it is umparseable.

=COUNTIFS({CDHS Tribal Team Range 1}, "Consultation", {CDHS Tribal Team Range 2}, "Completed", ({CDHS Tribal Liaison Team Activity Log Range 1}, CONTAINS("Ute Mountain Ute Tribe", @cell)))


Best Answer


  • Maria Watters
    Maria Watters ✭✭✭✭✭

    @Ramzi K

    Thank you! That was the problem!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!