Not able to get Countif to work with Contains

Options
Gopikrishna Mamidipudi
Gopikrishna Mamidipudi ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I have sheet that has a column called Legal Tasks. I'm trying to write a Countif formula that counts the number of times the word in Column2 appears in the Legal Task column.

As the formula stands it is trying to do an exact match, however my intent is to include in my count everytime the word appears by itself or with the some others.

In the screenshot the {Employee-LegalTask} range is the entire Legal Task Column.

Any help appreciated.

Countif.GIF

Legaltasks.GIF

Comments