Skip to main content

IF formula when field "contains" select text

  • December 11, 2021
  • 2 replies
  • 1939 views

Forum|alt.badge.img+3

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.
Thanks.

2 replies

Justin_Barrett
Forum|alt.badge.img+21

Use the FIND() function for this use case:

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

Philo
Forum|alt.badge.img+6
  • Participating Frequently
  • July 31, 2023

Hiyya, i found this thread as I was also searching for an IF formula that pulls up specific text from a cell.

 
IF({FIELD}="SPECIFIC TEXT", "CERTAIN VALUE")