COUNTIF and CONTAINS function

Angela Logie

Looking for help as to why the below formula isnt working:

=COUNTIFS({Intake - Project Customer Satisfaction Sur Range 7}, "Professional Services", {Intake - Project Customer Satisfaction Sur Range 6}, CONTAINS([Primary Column]@row, @cell))

Let me know if you need any additional info.

Thanks

SteyJ

https://community.smartsheet.com/discussion/113250/countif-and-contains-function

Hello @Angela Logie

What error are you getting when trying to use this formula?

Angela Logie

Actually no error, just "0" but that's incorrect

Paul McGuinness

Hi @Angela Logie

Normally when a cross sheet formula isn't doing as expected especially something as straightforward as yours I would check that the ranges are correctly assigned.

So i would check that the two ranges:

{Intake - Project Customer Satisfaction Sur Range 7}

{Intake - Project Customer Satisfaction Sur Range 6}

are highlighted / selected correctly as sometimes when selecting ranges cross sheet the selection doesn't lock in correctly.

If that's not the issue, I would then check that the criteria are correct and the columns are correctly formatted.

Hope that helps

Thanks

Paul