Nested IF() with FIND() and BLANK()

IF(
  {SLPs Licenses (from SLP Onboarding Link)},
  IF(
    FIND( "MI", {SLPs Licenses (from SLP Onboarding Link)} ),
    "SLP",
    "Applying"
  ),
  "Candidate"
)

Thank you so much! That’s brilliant! Now to figure out why that worked. :thinking:

It is nested IF statements. The outter IF statement checks if there is a value in your field. If your field has a value, the formula evaluates the inner IF statement. If your field does not have a value, the formula returns “Candidate”.

The inner IF statement checks if the string “MI” exists in the field. If the string exists, it returns “SLP”, and if the string does not exist, it returns “Applying”.

Each IF statement has three parts (parameters): the condition, the “true” result, and the “false” result. In this case, the “true” result of the outter IF is the result of the nested IF.

You can see that each IF has three parts by looking at the indent level of each line. This is easiest to see in the inner IF statement. The inner IF starts on line 3 and ends on line 7 (closing parenthesis), with one parameter per line on lines 4, 5, and 6.

The outer IF also has three parameters. The outer IF starts on line 1 and ends on line 9 (closing parenthesis). The first parameter is on line 2. The second parameter is the nested IF on lines 3-7, and the third parameter is on line 8.

Another thing worth pointing out here is how BLANK() isn’t really all that useful in Airtable, notice how IF(FieldName,“Something”,“Nothing”) will produce the same results as the much wordier "IF(FieldName=BLANK(),“Nothing”, “Something”).

That’s because it’s basically saying IF(FieldName exists,do this, otherwise do that)

Or just leave the response empty “” to condition a blank of your own.