Multi-select fields containing a value with a " (double quote) in it yield unexpected results with formulas—essentially because Airtable seems to escape double quotes in arrays with another double quote rather than a backslash or something else.
Here’s a series of formula results on a multi-select field named {multi} containing a single option with the value: 6" Bar Pull
Formula: {multi}
Result: “6"” Bar Pull"
Formula: FIND('6" Bar Pull",{multi})
Result: 0
Formula: FIND(‘6" Bar Pull’, REPLACE(multi, FIND(’""’, multi), 2, ‘"’))
Result: 2
