IF HAS Formula to Return Email in Contact Field


I have a sheet that includes a multiselect contact field with RA names (On-Site RA(s))and a second contact field (Manager).

When [email protected] is one of the emails in the On-Site RA(s) field, I want [email protected] returned in the Manager field.

I have added the IF HAS formula you see in the example in the Manager field, but it returns a blank field, not [email protected] as I want to be returned.

What am I missing? Thanks for your help!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!