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!