
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 10, 2021 04:00 PM
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.
Reply
2 Replies 2

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 10, 2021 04:03 PM
Use the FIND()
function for this use case:
IF(FIND("Member", Field), "Member", "Nonmember")
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 31, 2023 12:41 AM
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")
