
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 23, 2023 02:10 AM
I'm trying to write a formula to check whether a lookup field contains a specific value.
These lookup fields might contain one or multiple values, e.g.
- apples
- apples, pears
- pears, bananas, strawberries
I've been using the formula
IF(FIND("apples", {fruitName}), "yes", "no")
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 23, 2023 02:49 AM
The FIND() function works with strings, not arrays. So add &"" to convert the data of your lookup field into a string.
IF(FIND("apples", {fruitName}&""), "yes", "no")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 23, 2023 02:49 AM
The FIND() function works with strings, not arrays. So add &"" to convert the data of your lookup field into a string.
IF(FIND("apples", {fruitName}&""), "yes", "no")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 26, 2023 12:33 AM
Amazing, this worked perfectly. Thank you very much @Databaser
