Help

Find() Not working

1170 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Rose_Haft1
8 - Airtable Astronomer
8 - Airtable Astronomer
See Solution in Thread

‎Feb 22, 2021 05:52 AM

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

0 Kudos
Reply
1 Reply 1
Justin_Barrett
18 - Pluto
18 - Pluto
See Solution in Thread

‎Feb 22, 2021 06:39 AM

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:

Reply
Copyright © 2024 Khoros, LLC