This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
