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

Tracey Tume

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

Andrée Starå

Hi @Tracey Tume

Try something like this.

=IF(Designer@row = "Sylvia"; "sylvia@domain.com")

The same version but with the below changes for convenience.

=IF(Designer@row = "Sylvia", "sylvia@domain.com")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Tracey Tume

Try something like this.

=IF(Designer@row = "Sylvia"; "sylvia@domain.com")

The same version but with the below changes for convenience.

=IF(Designer@row = "Sylvia", "sylvia@domain.com")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tracey Tume

Oh THANK YOU so much, Andre! :) Worked a treat!

Regards Tracey

Andrée Starå

@Tracey Tume

Excellent!

You're more than welcome!

RachelShark

Hello! This formula worked for me in a similar situation. Curious if there is a way to add additional options? If the name is another option? =IF(Designer@row = "Sylvia", "sylvia@domain.com") AND ADD =IF(Designer@row = "Daniel", "daniel@domain.com") for multiple designer names. Thanks!

RachelShark

Hello! This formula worked for me in a similar situation. Curious if there is a way to add additional options? If the name is another option? =IF(Designer@row = "Sylvia", "sylvia@domain.com") AND ADD =IF(Designer@row = "Daniel", "daniel@domain.com") for multiple designer names. Thanks!