Help

Re: IF formula error message

Solved
Jump to Solution
2667 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Monnie76
4 - Data Explorer
4 - Data Explorer

Hi everybody

I am having trouble with an IF formula.

As background – I have a table that includes three multiselect fields. I am trying to count the number of instances of a particular keyword (could be a single word, or multiple) in each field. Below is the formula I am trying to use:  

IF({KW Taxonomy L1}=Natural Sciences,"Yes","No")

Which isn’t working.

The fields are not linked to another table. Should they be? Am I barking up the wrong tree and should be using another formula entirely?

Many thanks

1 Solution

Accepted Solutions
pressGO_design
10 - Mercury
10 - Mercury

Try

IF(FIND("Natural Sciences", {KW Taxonomy L1}), "Yes", "No")

See Solution in Thread

2 Replies 2
pressGO_design
10 - Mercury
10 - Mercury

Try

IF(FIND("Natural Sciences", {KW Taxonomy L1}), "Yes", "No")

Monnie76
4 - Data Explorer
4 - Data Explorer

ked like a dream - thank you so much!