COUNTIF Formula Only Works on Certain Rows

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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!