MULTIPLE IF/OR

Is there a way to have an IF/OR statement for the following:

Column A represents the initials of an internal contact at company. Column A is part of a sheet which has 300 rows. Column A could have initials KA, PP, or JM. I need a formula which will look at Column A, read which set of initials are present, and return a defined email address. The defined email addresses would be:

KA = [email protected]

PP = [email protected]

JM = [email protected]


Column A Column B

VP Initials Email Address

KA

JM

PP

PP

KA

KA

PP

JM

My intention is to use the email addresses in an automation.

Any help would be appreciated.

Tim

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!