HELP - Contains IF

Caravan

Hi,

Please help. Can't understand why the below not working.

Helper is check box but I'm getting blanks. :-(

Thanks much

Kimbh ✭✭✭

06/20/23

Hi, how do I do a formula that will count keyword or keyword phrase? For example: How do I count have many times in a column the phrase "6.12 applies" was used.

Thank you

Answers

• Staylo95 ✭✭✭✭
• 06/20/23
• This should work if you sub out the primary column for the range you want to count: =COUNTIF([Primary Column]:[Primary Column], CONTAINS("6.12 applies", @cell))

Ray Lindstrom

Hi @Caravan

I used this formula (seems to be the same as yours):

=IF(CONTAINS("/", Owner@row), 1, 0)

and received the proper value of 1. Here's what it looks like:

Here it is with the column type changed to checkbox:

Caravan

Thank you Ray.

I've converted column to text just to see if it makes any differences b/c I'm stumped. Basically, it's not recognizing the "/".

Finally, found the culprit. Owner column was a 'contact list'. I guess you can't search strings if the column property is 'contact list'. Hmmm

Ray Lindstrom

@Caravan,

Glad you got it working!

All the best,

-Ray

Paul Newcome

CONTAINS does not work on contact type columns but the FIND function does.

=IF(FIND("/", Owner@row)> 0, 1)