Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF formula error message

Topic Labels: formula
Solved
Jump to Solution
87 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Try

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

See Solution in Thread

2 Replies 2

Try

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

ked like a dream - thank you so much!