Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

IF formula when field "contains" select text

Topic Labels: Formulas
3724 1
Showing results for 
Search instead for 
Did you mean: 

I have a Multiple Select field that has several choices, like Camp, Membership, Donation. I want to create a Formula field that says Member or Nonmember. I know how to make an IF question for blank fields, but not for a specific Select from a field. I tried just IF(Field = “Member”), “Member”, “Nonmember”), but that doesn’t work.

1 Reply 1

Use the FIND() function for this use case:

IF(FIND("Member", Field), "Member", "Nonmember")