Hi @Rebecca_Niles - your formula should work - maybe there’s an additional character in the linked field that isn’t in the formula?
I did a similar thing here:
The two formulas both work with a single linked field.
Formula 1 is:
IF(Person = 'Jim', 'Yes', 'No')
Formula 2 is:
IF(FIND('Jim', Person), 'Yes', 'No')
The difference is that Formula 2 will work if more than one record is linked: