May 31, 2018 01:39 PM
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
May 31, 2018 01:49 PM
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.
May 31, 2018 08:46 PM
Exactly what I was looking for. Makes sense. Thanks so much!