IF ? from name to email-adress



I have names f.e. "Joerg Schmidt" in one cell and want to automatically change them into their email-address in the neighbour cell.

Since it concerns only <10 names it seems a simple task? With the if-formula ?

If I would build an general contact sheet could I have a formula like "lookup" ??

Hope you can help ;-) Thx

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!