Help

Syntax error help! IF statements checking multiple select and checkbox fields

Topic Labels: Formulas
1267 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lindsay_Speer
5 - Automation Enthusiast
5 - Automation Enthusiast

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", 
" "

)

1 Reply 1

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.