Help

Help with nested if formula

713 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Rita_Roloff
4 - Data Explorer
4 - Data Explorer

Response I am getting:
Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

The formula:
IF ({Num Porosity} >50, “High Porosity”, IF({Num Porosity} < 20, “Low Porosity”, “Normal Porosity”))

1 Reply 1

Welcome to the community, @Rita_Roloff! :grinning_face_with_big_eyes: If you copied that formula directly from your formula field, the most glaring issue is the space between IF and its opening parenthesis. It should be:

IF(...

not

IF (...

The same goes for all of Airtable’s functions.

If (no pun intended) that’s not the issue, the next thing to check are the quotes. If you had copied a formula from elsewhere in the community, for example, it’s possible that you captured some “curly” quotes. Airtable is picky about quotes, and only works with non-styled “straight” quotes in formulas, as this cleaned up version of your formula uses:

IF({Num Porosity} >50, "High Porosity", IF({Num Porosity} < 20, "Low Porosity", "Normal Porosity"))