Multiple IF formulas

Hi I have a question relating to expressions. I have a form whereby the user email entered automatically fills out the next column [Operator]. In the AppSheet App, Auto compute, Formula for column Operator (Name) I have the following formula entered:
IF([User Log In] = “JohnDoe@gmail.com”, “John Doe”, John Doe’’)
What I want to do is add more user emails and different operator names only I don’t know how to write this expression. Just for clarification I would like it to be like this;
IF([User Log In] = “JohnDoe@gmail.com”, “John Doe”, John Doe’’) + IF([User Log In] = “JaneDoe@gmail.com”, “Jane Doe”, Jane Doe’’) + IF([User Log In] = “JohnSmith@gmail.com”, “John Smith”, John Smith’’)

2 Likes

Hi @Steve that worked perfect. Thanks for the guiding me in the right direction. This worked:
IFS(
(USEREMAIL() = ***@gmail.com), “James”,
(USEREMAIL() = ***@gmail.com), “Jack”,
TRUE, “”,
)

Cheers for the help.

2 Likes

Also:

1 Like