Whats wrong with this formula?


I'm using this in a metric sheet to count the term in a sheet that has multiple entries per row from a drop down list. It currently produces the error message #INVALID OPERATION.

=COUNTIF({PH Roadmap Intake sheet Range 1}, CONTAINS([Primary Column]@row))

I was attempting to copy the one @Paul Newcome provided on 9/8/21 but somethign obviously (not to me) not correct.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!