Skip to main content

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

Try

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


ked like a dream - thank you so much!


Reply