Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF formula error message

Topic Labels: formula
Solved
Jump to Solution
3317 2
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!