Welcome to the Airtable community!
Using lookup fields in formulas can be tricky because lookup fields are usually arrays, not simple values. One option is to convert the lookup to text string using & ""
.
IF({Job Requests} & "" = "Floorplan", 'TRUE', 'FALSE')
Also note that this formula will only return "TRUE"
if there is an exact match, and not if there are any other words in the lookup.
Welcome to the Airtable community!
Using lookup fields in formulas can be tricky because lookup fields are usually arrays, not simple values. One option is to convert the lookup to text string using & ""
.
IF({Job Requests} & "" = "Floorplan", 'TRUE', 'FALSE')
Also note that this formula will only return "TRUE"
if there is an exact match, and not if there are any other words in the lookup.
Thanks so much! I ended up using the below formula as the word “floorplan” could appear anywhere in the string and along with other words in the lookup field like you mentioned.
(IF(SEARCH(“Floorplan”, {Job Requests}&’’)>0,‘1’,‘0’))
I was then able to use the numerical value in further equations.