Use a "button" field to enter a value for that sin...

[esu]

I'm trying to automatically populate emails depending on team member names.

So if "John Smith" then in this column "john.smith@email.com" ""

And if "Kate Jones" then "kate.jones@email.com" ""

etcetcetc

for about 30 team members. I can get the first formula to work but how do i do it for multiple?

Tried this but didnt work

IF({Name} ="x", "email x"

IF({Name} ="y", "email y",

 ) )

[esu]

found it -- i was missing an &.

close each if statement, add & between

[Alexey_Gusev]

Hi,
Airtable has formula operator exactly for multiple choice:

SWITCH({Name},
'x','email x',
'y','email y',
'default value(optional)')

but in general, hardcoding such tables in formulas is a bad practice. as soon as you start using it in 2 or more places, and team list will change, you will find it harder and harder to maintain.
it's pure Airtable basics - when you store list of team members as a single source of truth, when you need email and other info, you add field, linked to 'Team list' table and get all additional data via lookups.