If text formula - if one cell = a name then another cell = an email address. See example below

I want to create a formula that looks at the Designer cells text and if that cell equals a certain designers name the Designer Email cell equals their email address

I am a novice, as you can tell, and would appreciate help :)

Thank you

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!