create a contact list based on three columns with emails and a 4th column with the drop down

Options

Hi, we're combining a legacy mailing list with the current one and would like to use the same sheet to gather new emails. because of this, we have a more complicated than usual setup.

Column 1 - Personal email

Column 2 - Current work email

Column 3 - Other email

Column 4 (drop down type) - Preferred email for Mailchimp communications (Choice 1: Personal email, Choice2: Current work email, Column 3: Other email).

Column 5: Final contact list (to be built)

I need a formula that would select a cell value from Columns 1-3 based on Column 4 choice and create a final single contact list in Column 5.

Is it possible? thank you for your help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!