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.

Find() Not working

1294 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Rose_Haft1
8 - Airtable Astronomer
8 - Airtable Astronomer

Despite having standardized the look-up field, my table is giving very distinctly different answers in the formula field. An image of the formula field + look-up field are below. What could possibly be going wrong? What can I test to fix?

My formula is:

FIND(‘T003: Symptom’, {Rel_lookup_Terms_Type})

image

1 Reply 1

More often than not, a lookup field returns an array, not a string, and FIND() only works on strings. You can force-convert the output of any field into a string by concatenating it with another string, including an empty string:

FIND('T003: Symptom', {Rel_lookup_Terms_Type} & "")

A deep dive into field types and what they return—including lookup fields returning collections of those types—can be found here: