Skip to main content

I am trying to create a formula field result where if the box for “LMI” is not checked, AND someone has “Home Performance” in the multiple select field of things they are interested in, the words “enroll in Comfort Home” appear.



Logically I think I know how to do this, having read lots of these help posts… but I keep getting syntax errors. HELP! What am I doing wrong?



IF(


AND(


FIND(


“Home Performance”,


{Interested in}


),


FIND(


“0”,


{LMI}


)


)



"enroll in Comfort Home", 


" "


)

This should be valid syntax right here:



IF(


   AND(


      FIND(


         "Home Performance",


         {Interested in}


      ),


      FIND(


         "0",


         {LMI}


      )


   ),


   "enroll in Comfort Home", 


   " "


)


I think you were missing just 1 comma, and possibly the curly quotes were getting you too. Airtable’s formula editor only likes straight quotes.

Reply


Terms & Conditions