Using IF formula in Contact column - displaying name only -- not contact info


Hello community!

I am attempting to use an IF statement in a contact column to insert a vendor name depending on the company name in the associated row.

=IF(Company1 = "Hospitals", "Vendor Name1", "Vendor Name2")

The correct names are displaying, but it is name only -- not a true contact (no email address).

I can enter the email address in the formula instead of first and last name, but then it only displays that -- not the vendor's name.

A contact record should have name, plus email address. These are vendors that are already contacts in our system.

How do I get an actual contact to display? Is this possible?

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!