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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!