COUNTIF Formula Only Works on Certain Rows

John- Michael Diedrich

Hey Smartsheet Community, I am currently being stumped by this formula that for some reason only works in a few rows.

It is a COUNTIF formula that is counting the number of assignments each person has. I will paste it below:

=COUNTIFS({Resource Name}, FIND([Qarbon Owner]@row, @cell) > 0)

I have 29 people that I need to count their number of tasks assigned, and it only works on 2 of the rows for some reason.

Some more info on this, these were running fine until recently a coworker changed some of the data in the sheet and that's when it stopped working.

Any help here is much appreciated.

Thank you

Mark Cronk

Try:

=COUNTIFS({Resource Name}, CONTAINS([Qarbon Owner]@row, @cell))

Mark

Paul Newcome

If you are using a contact type column, the CONTAINS function will not work. What changes did the other person make?