Does anyone know if it’s possible to run an if() formula for a keyword in a lookup field. (see screenshots below)
Im looking to return a ‘true’ or ‘false’ if it contains the word “Floorplan” however i believe that the lookup fields are not considered...
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 t...
