Formula with IF and FIND


#1

I’ve read through this post and just can’t understand how the FIND and IF formulas work together – and there is no documentation on Airtable for formulas, other than their definitions.

What I really need is:

• IF the column “Associate” CONTAINS “Person A” OR “Person B” OR “Person C” – AND if the column “Principal” has the value of "Yes – to then display the number 5.

• The “Associate” column can contain multiple people in one record, so an IF formula won’t work.

• If “Associate” includes any of those Persons BUT the “Principal” column does NOT have value “Yes,” then the returned value is 0.

I have been wrestling with this for a long time but feel the solution is simple. Please advise!

Javier


#2

Try this:

IF(
  OR(
    FIND(
      "Person A", {Associate}
    ),
    FIND(
      "Person B", {Associate}
    ),
    FIND(
      "Person C", {Associate}
    )
  ),
  IF(
    {Principal} = "Yes",
    5,
    0
  )
)

I’m sure this won’t take into account other things you might need it to do (like what to return if none of those “Persons” is found in “Associate”) - but try this first, and if it does the main thing you need it to we can refine it more based on your response.
image


#3

Exactly what I was looking for. Makes sense. Thanks so much!