count if / v lookup formula

I'm trying to count the number of times the issue "- Originating Agency should be the origin of funds for University pass through funds" appears on a scrub report. I was using a simple count if statement at first but ran into an issue when two issues were reported for one proposal in a cell. I thought a work around would be to use a count if / v lookup formula to count the number of times a specific string appears. Looking at the reference sheet you can see it appears twice, along with the other issues in the cell.

Am I on the right track? This is what I have started but am stuck... Thank you in advance for help.


Best Answer

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    Answer ✓

    @Ashlynn, how did you format your COUNTIF? Did you just set it = "- Origin..."? Have you tried adding a CONTAIN instead? That way it doesn't matter how many items are in the cell, as long as it contains that string.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!