
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
