Help with nested if formula

780 1
Showing results for 
Search instead for 
Did you mean: 
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 (...

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