Skip to main content

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

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.

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.


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

Reply


Terms & Conditions